To migrate sqlserver 2005 To 2016

Nepethya Rana

10y839

What are the process and steps to follow to migrate database from 2005 To 2016 without affecting the application reading and writing in the old database server?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava10y ago
Hi Gaurav,

I hope you have to server.

1) You can a Full backup of all databases. and deatch

2) after that restore all on other server. and attach .

Please don't forget to mark as answer if this helps.
0
Tejas Trivedi10y ago
Hi Gaurav,

Hope , you have separate instance running for SQL Server 2016. Follow the below steps to start your migrations.

1) Take a Full backup of all databases that will be migrated.

2) Restore SQL Server 2005 database to SQL Server 2016 instance. It should restore, if it fails, Try to first migrate it to SQL Server 2008/R2. Please note that all service packs should be similar in source and destination servers

3) Move Logins and SQL Agent jobs. You can get scripts and execute it on SQL server 2016 instance

Hope, this will help you out. Feel free to write if you need more information on this.

Please don't forget to mark as answer if this helps.
0
Midhun Tp10y ago
Hi,

Please go through below links-
https://msdn.microsoft.com/en-us/library/mt168847.aspx
http://pragmaticworks.com/Training/Details/Migrating-SQL-Server-2005-to-SQL-Server-2014-and-Azure
0
Guest User10y ago
Migrating to SQL Server http://m.sqlmag.com/sql-server-2014/migrating-sql-server-2014
0