![]() ![]() Notification to all involved and impacted stakeholders Pre upgrade – performance metrics to compare after upgrade performance Plan database backups – Full backup, differential backup and transactional log backup Plan to manage other technology features – log shipping, clustering, database mirroring, replication, full-text search, DQS, etc. Identify SQL Server services – Database engine, SSIS, SSAS, SSRS, etc.ĭatabase collation upgrade considerations Run data migration assistant to know Breaking changes and Behavior Changes Study deprecated features and discontinued features I’ve captured a high-level list of activities, all of which are required in the migration process. You must have a prepared master plan for a successful SQL Server migration. This activity will help you to understand the behavior of the existing SQL Server and what changes need to be made to migrate to a newer version of SQL Server. In this article, we will walk through a step by step approach to assess your SQL Server migration using DMA. In a previous article we discussed Data Migration Assistant (DMA) and how DMA can help in migrating an older version of SQL Server to SQL Server 2017.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |