15 Performing your first advanced SQL Server instance migration

 

Within the SQL Server community, simplified migrations sparked the adoption of not just dbatools but PowerShell as well. The videos showing the migration of all parts of a SQL Server instance containing a SharePoint installation to a new SQL Server instance such as https://youtu.be/hg8tovMRX2k resonated with DBAs.

However, as DBAs ourselves and with feedback from the community, we know that SQL Server migrations are often not as simple as the video shows. Doing a migration of large databases using the backup and restore method or even detach and attach will mean the business agreeing to a long downtime for the systems relying on those databases whilst all of the data is moved. SQL Server instances that have existed for a long time may have a large number of SQL Agent Jobs, Logins, Linked Servers or other objects that are no longer in use and migrating those also is unnecessary.

This chapter will not resolve all of these scenarios but will provide you with the knowledge to be able to plan, test and execute your complex migrations. Testing is important; we advise that, if you are able to, you perform thorough testing of these complex tasks before you implement them on your systems. Scripting these with dbatools enables you to keep the scripts so that you can repeat the same tasks on your production instances by changing the values for instances.

15.1 Databases

 
 

15.1.1 Backup & Restore

 
 

15.1.2 Detach & Attach

 
 

15.1.3 Stage large databases for migration

 
 

15.1.4 Other database migration options

 
 
 

15.2 Logins & Groups

 
 

15.3 SQL Agent Objects: Jobs, Operators and more!

 
 
 
 

15.4 Linked Servers

 
 

15.5 More migration fun?

 
 
 

15.6 Lab

 
 
 
sitemap

Unable to load book!

The book could not be loaded.

(try again in a couple of minutes)

manning.com homepage
test yourself with a liveTest