Datacenter’s and companies everywhere generally rely on a core piece of software to store their data and metrics, SQL Server. It’s nice to keep it up to date, but sometimes, and a lot of the time, if it’s not broken, don’t fix it. SQL Server has been around for quite a while, there are many databases hosted by SQL Server. Microsoft has released many upgrade advisors over the years, but recently the SQL Server team has overhauled their traditional SQL Server Upgrade Advisor and have created a new product – SQL Server Data Migration Assistant (DMA), which is different than SQL Server Migration Assistant (SSMA). To pull off a successful migration or upgrade, you need to do your detective work.
Read More