Compatibility Level (Tips SQL Server)
This post is intended to include the steps to migrate and change basic version of SQL SERVER 2005 data on 2014
It’s simple to make a BACKUP of Full aging database (SQL 2005), do the RESTORE of the database on the target server (Data Log & Database).
However consider changing the COMPATILITY LEVEL on the 2014 base,
ALTER DATABASE database_name
SET COMPATIBILITY_LEVEL = { 90 | 100 | 110 | 120 }
Note : 120 is the compatibility level for SQL SERVER 2014
Link : https://msdn.microsoft.com/fr-fr/library/bb510680(v=sql.120).aspx
