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 for our new environment to work as expected. Just expand all of the data trees throughout SQL Server Management Studio (SSMS) to see how many components can potentially be migrated. We actually used SSMS as a guide to visualize 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 in table 16.1, which is limited to SQL Server Database Engine, so SSRS, SSAS, SSIS, and so on are not mentioned. Ultimately, this list covers most of the potential objects to be migrated but is not exhaustive.

16.1 Logins and 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