Changing the SQL version of my database

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

You have a database that was created in an earlier version of SQL and restored onto a later version.  It may be necessary to change the SQL version of your database.

There are potentially significant performance improvements to be made by making sure the compatibility level of your database matches that of the SQL Server version. When you restore a database from an older version of SQL Server to a newer version, by default the restored database has the compatibility version set to the older SQL Server version. It is recommended to change the compatibility level of the database to match that of the SQL Server version.

 

Step-by-step guide

SQL Advanced programming skills required

This tasks needs advanced SQL programming skills.

Review this link and follow the steps detailed - https://msdn.microsoft.com/en-AU/library/bb933794.aspx