Upgrade a Database from Microsoft SQL 2008 to Microsoft SQL 2016

Channel:
United Kingdom SBCODE
Subscribers:
24,900
Published on ● Video Link: https://www.youtube.com/watch?v=7DNYXKoJiw4


Duration: 3:00
62,870 views
154

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.



Other Videos By SBCODE


2016-01-26How to Host Multiple Websites using Node.js
2016-01-25RESTful CRUD using GET, POST, PUT and DELETE
2016-01-24Remote C++ Development on Linux using NetBeans IDE on Windows
2016-01-23Install Telnet on Windows 10
2016-01-22TCPDUMP
2016-01-21TDD in JAVA using JUnit and NetBeans IDE
2016-01-21Command Line C++ (Linux G++ Compiler)
2016-01-21Command Line JAVA
2016-01-21Command Line C#.Net
2016-01-21Command Line C++.Net
2016-01-20Upgrade a Database from Microsoft SQL 2008 to Microsoft SQL 2016
2016-01-19Peer to Peer Replication in Microsoft SQL 2012
2016-01-18SpiderMMO
2016-01-18Creating and connecting to an Azure VPN
2016-01-16Creating and failing over an Azure SQL 2014 Always On High Availability Cluster
2016-01-14Self Hosted REST Microservice using OWIN and ASP.NET Web API 2
2016-01-13Seans Simple JAVA SOAP MicroService
2016-01-13Consuming and Displaying a RSS feed with Flash ActionScript 3
2015-10-15Playing BirdMMO Multiplayer PvP
2015-10-05BirdMMO
2015-09-12Marble Blast Gold Advanced Levels


Tags:
sql 2008
sql 2016
upgrade sql database
mssql 2016