16 Performing your first advanced SQL Server instance migration, part 2

 

Now that we have a plan to migrate our databases, we need to consider the other objects that are required in order for our new environment to work as expected.

All you have to do is expand all of the data trees throughout SQL Server Management Studio to see just how many components can potentially be migrated. We actually used SSMS as a guide to give a visual of the things we’d need to migrate, outside of SSRS, SSAS, SSIS, and other non-engine related services.

Some of these objects can be seen Table 16.1, which is limited to SQL Server Database Engine, so there will be no mention of SSRS, SSAS, SSIS, etc. Ultimately, this list covers most of the potential objects to be migrated, but is not exhaustive.

16.1 Logins & Groups

 
 
 
 

16.1.1 Which logins/groups are still needed?

 
 
 

16.2 SQL Agent Objects: Jobs, Operators and more!

 
 
 

16.3 Linked Servers

 

16.4 More migration fun

 
 
 

16.5 Hands-on 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