Which edition of SQL Server is needed when using Vault?

Autodesk Support

May 29, 2024

Products and versions covered

Issue:

The article covers the following issues:
  • How to determine which edition of SQL Server (some call it incorrectly a version) should be used, the Express, the Standard, or any higher one?
  • Where is the best practice to do sizing? Is it in the number of documents, like 10,000 files or size of documents, like 10 Terabytes files the main indicator?
  • Is there any restriction on which editions of SQL works with each version of Vault - Basic or Professional?

Causes:

  • Software planning
  • Software licensing

Solution:

For edition of SQL Server

Refer to the post "Comparing Different Editions of MS SQL" on the blog Cracking the Vault.

For Size of Documents

Note: It is always possible upgrade the Express edition to any higher if necessary.

For Restriction on SQL Editions:

  • There is no restriction on which edition of SQL server can be used with Vault. Basic and Professional all will work with Express, Standard or Enterprise editions of SQL Server.
  • Autodesk cannot recommend a 3rd party software to use the choice must be made by the system administrator 

See Also:

  • See this guide for pre-installing a Vault SQL Server instance. this guide can be used with any licensed or express version of SQL: Pre-Install SQL Server for Vault
Note:It is possible allow the Vault to install the SQL server then upgrade the SQL server edition to the desired level.

Products:

Vault Basic; Vault Collaboration; Vault Manufacturing; Vault Professional; Vault Workgroup;

Versions:

2017; 2012; 2013; 2014; 2015; 2016; 2019; 2018;

Was this information helpful?

Need help? Ask the Autodesk Assistant!

The Assistant can help you find answers or contact an agent.

Ask the Assistant

What level of support do you have?

Different subscription plans provide distinct categories of support. Find out the level of support for your plan.

View levels of support

Feedback Link