The Data Migration Assistant (DMA) offers you the ability to perform a feature assessment against your SQL Server database. The DMA will not work if you try to perform an assessment of a source database against an older target version.
Today Microsoft released a KB article to provide guidance for SQL Server installations in response to the Meltdown and Spectre side-channel attacks. You should take the time to review that KB article. Here’s what Microsoft has to say about performance.
After upgrading to SQL Server 2016 is complete you will need to perform a series of tasks to verify that database is ready to be handed over to the end users for further testing. This post will provide you a checklist of items to review after the upgrade is complete.
Let’s look at the steps involved in upgrading to SQL Server 2016.
Trust me when I tell you that the extra legwork now will save you headaches later. Here is my checklist of items for upgrading to SQL Server 2016 that you must review before any data is migrated.
There are new performance features, new security features, and new scalability features in SQL Server 2016 that make it worth the time and effort to upgrade.
