Supported Microsoft SQL Server versions

You can use Microsoft SQL Server as the vault database engine. Refer to our lifecycle policy for information about the supported versions. These editions are supported: Microsoft SQL Server Express, Standard, and Enterprise. Refer to Microsoft documentation to make sure that your Microsoft SQL Server edition has the necessary features and capabilities for your environment. M-Files supports the use of Microsoft SQL Server on Microsoft Windows.

Microsoft SQL Server Enterprise Edition supports compression of table data and indexes. Compression can reduce database size and disk input/output activity, but it can also increase CPU load.

Microsoft SQL Server supports updateable columnstore indexes. These can improve performance with sub-levels of views (such as Documents by project). This is especially beneficial when empty virtual folders are set to be hidden.

Guidelines for version selection, updates, and upgrades

  • When you take Microsoft SQL Server into use as the database engine, we recommend that you use the latest version of Microsoft SQL Server that M-Files and your operating system support. For Microsoft SQL Server software requirements, refer to Microsoft documentation.
  • Make sure that the server machine always has the latest service pack and cumulative updates installed. To do this, refer to Latest updates for Microsoft SQL Server.
  • To upgrade your version of Microsoft SQL Server, refer to Upgrade SQL Server.