Upgrade a Database from Microsoft SQL 2008 to Microsoft SQL 2016



Upgrade a Database from Microsoft SQL 2008 to Microsoft SQL 2016

Upgrade a Database from Microsoft SQL 2008 to Microsoft SQL 2016

I take the SQL 2008 database offline,
copy the .mdf and .ldf into a zip file,
copy the zip file to my SQL2016 Server in another part of the world using Remote Desktop Connection,
unzip the file into a new folder on the new server,
Attach the Database MDF and LDF files,
Go to the properties, then options menu item, and select Compatibility Level = SQL Server 2016,
press OK and it’s done.

Comments are closed.