Upgrade Advisor vs Data Migration Assistant

Category: sql server setup


peter daniels on Sat, 14 Apr 2018 16:21:44

I am hearing that SQL  Server Data Migration Assistant (DMA) is replacing  SQL Server Upgrade Advisor for upgrades from 2016 on.  I'm also hesitant to rely only on the new DMA, especially since it seems to be focused on database level upgrade checks rather than server checks.  Am I missing something here?  I would like a tool that also checks min server disk space, minimum OS and HW, upgrade version path prerequisites, and any other upgrade blockers, etc.  Is there an easy automated way to get those type of checks on a enterprise level for multiple server instances?  BTW, I also DO really love the DMA and associated power shell scripts to load into a DB!





Teige Gao on Mon, 16 Apr 2018 06:02:47

Hi peter daniels,

SQL Server Data Migration Assistant (DMA) not only do the database update check, it also checks the instance-level like some features, what's more, it also helps us make the best use of new features.

>> I would like a tool that also checks min server disk space, minimum OS and HW, upgrade version path prerequisites.

These items will be checked during upgrade, in the feature rules step, all the above items will be check before it operating upgrade.

Best Regards,


Shanky_621 on Mon, 16 Apr 2018 06:14:40

It does more than database upgrade believe me but for hardware and OS checks you just need to follow SQl Server 2016 Hardware and Software requirements. The disk space requirement would not change like if DB is 100 G in SQL Server 2008 it would be same in SQl Server 2016. what DMA does is it looks for breaking changes that would cause application or database queries to fail. Previous UA has few bugs when reading big schema this is fixed in DMA

Martin.Cairney on Mon, 16 Apr 2018 12:21:59

The DMA FAQs describes the differences.

The big one for me is that trace files are not analysed in DMA.  However if you combine with DEA to do full A/B testing of your workload then you should get full coverage.

peter daniels on Thu, 19 Apr 2018 15:17:28

Thank you.

Are you saying that in order to do a real check for upgrade blockers, I need to actually run the upgrade?

It would be nice to have an automated way to have these full install checks done in a scriptable fashion and saved to a repository like we have for DMA output.

Also, where do I fine the server/instance level output for the DMA?  Everything seems to be associated with at the database level.

peter daniels on Thu, 19 Apr 2018 15:19:11

Thank you.  It would be nice if there was a tool that did HW and OS checks.  Do I just need to run the install to see if anything blocks the upgrade?