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.