What should the Compatibility Level be set at?

[c17]

We just moved our Vault database to a new server, running SQL 2016.

Everything went fine with the move, but we noticed that the Compatibility Level for all the Vault databases is set to SQL Server 2008 (level 100).

Is there a reason for this? Is it safe/advisable to move it to SQL Server 2016 (level 130)?

Thanks

[Tonya]

Hello,

According the this Microsoft page, SQL Server 2016 is compatible with 130, 120, 110, 100:

https://docs.microsoft.com/en-us/sql/t- ... rver-ver15

I'm not sure why the value didn't change. Did you restore the databases on the new SQL Server machine during the move?

Thanks,

Tonya

[c17]

Yes, we restored the SQL backup files from the old server to SQL S016 in the new server.

When you do that, SQL Server leaves the compatibility level as per the backup file (i.e., as it was on our old server). Our question is: Has Vault (the stored procedures, etc.) been tested with and validated to work with compatibility level 2016?

Thanks

[Tonya]

Hello again,

Yes, I can confirm that Vault version 10.x has been tested and is fully supported on SQL Server 2016. I have copied below a link to the Vault Compatibility Chart:

https://www.sourcegear.com/vault/docume ... chart.html

Tonya