Using Microsoft SQL Server as the Database Engine

Instead of Firebird, you can use Microsoft SQL Server as the database engine. We recommend that Microsoft SQL Server is used if the vault contains several hundreds of thousands of objects. With large vaults, Microsoft SQL Server provides better efficiency than Firebird. However, with Microsoft SQL Server, the administrator must be familiar with Microsoft SQL Server management.

With Microsoft SQL Server, the database server memory can be more efficiently used and the backup storage of large data vaults is improved. You can also switch to the mirrored database server without delay if necessary.

Note: Microsoft SQL Server licenses are not included in M-Files licenses. They must be purchased separately.

Migration to Microsoft SQL Server

See Migrating the Vault Database to Microsoft SQL Server.