Changing the SQL version of my database
- Beth Blok (Unlicensed)
- Mike Sheen
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