topic Re: SQL Express & Replication in Vault Forum

SQL Express & Replication

Neil_Cross — Wed, 07 Jun 2017 18:11:05 GMT

On the Microsoft Product Matrix they say that SQL Express is supported as a subscriber in merge replication, indeed you can install the replication features along with Express.

I appreciate SQL Express isn't listed in the supported platforms on Autodesks system requirements for replication, is that because it's an old document...? Often those AKN pages become out of date and poorly maintained. Or have Autodesk tested and deemed Express to not be suitable as a subscriber in a connected workgroup environment? Has anyone tried using SQL Express at a subscriber site?

I've got no intention to do this, I'm just writing a training course for an online e-training site and just want to get my facts right and to double check this before talking about it.

Re: SQL Express & Replication

ihayesjr — Wed, 07 Jun 2017 19:11:17 GMT

@Neil_Cross,

The documentation is not old. When we developed replication as a feature with Vault, we decided that including SQL Express could lead to performance issues and wouldn't be able to handle the load Vault environments would put on it. If Vault detects SQL Express, it will not allow you to configure replication.

Re: SQL Express & Replication

Neil_Cross — Wed, 07 Jun 2017 19:16:28 GMT

Exactly what I needed to hear, cheers

Re: SQL Express & Replication

matthewweake — Tue, 06 Mar 2018 22:48:09 GMT

Is this true for both Multiple Site and Workgroup Environments?

I want to use Vault Pro on SQL Express for Plant 3D with 4 users over 3 sites.

Re: SQL Express & Replication

ihayesjr — Tue, 06 Mar 2018 22:56:23 GMT

@matthewweake,

If you are configuring Vault replication, you cannot use SQL Express for Vault replication.

Re: SQL Express & Replication

matthewweake — Wed, 07 Mar 2018 00:39:20 GMT

Can we use SQL Standard or Enterprise a requirement?

Re: SQL Express & Replication

ihayesjr — Wed, 07 Mar 2018 01:37:45 GMT

Yes, please see the system requirements for the version you have.

https://knowledge.autodesk.com/support/vault-products/troubleshooting/caas/sfdcarticles/sfdcarticles/System-requirements-for-Autodesk-Vault-products.html

Re: SQL Express & Replication

matthewweake — Wed, 07 Mar 2018 02:00:37 GMT

It is a bit confusing when this article says to use Enterprise:

https://knowledge.autodesk.com/support/vault-products/learn-explore/caas/sfdcarticles/sfdcarticles/Steps-for-integration-Autodesk-Plant-3D-with-Autodesk-Vault-and-Autodesk-Vault-replication.html

Can you clarify the requirements for Vault Pro/Plant 3D with File Store Replication only?

Re: SQL Express & Replication

ihayesjr — Wed, 07 Mar 2018 14:37:12 GMT

@matthewweake,

Vault has a different method for replicating its database then Plant 3D. Plant 3D has a separate database with different replication methods and requirements. I have given you the requirements for Vault. The article you linked, which doesn't work, is most likely talking about the Plant 3D requirements, not Vaults.

Re: SQL Express & Replication

matthewweake — Wed, 07 Mar 2018 19:41:31 GMT

The link had a space on the end stopping it from working!

https://knowledge.autodesk.com/support/vault-products/learn-explore/caas/sfdcarticles/sfdcarticles/Steps-for-integration-Autodesk-Plant-3D-with-Autodesk-Vault-and-Autodesk-Vault-replication.html

Looks like I will have to ask this question in the Plant forums.

Thank you for your help.