DMA - A safe way to migrate SQL Server database objects
SQL Server database objects migration was not so easy earlier as of now with the help of DMA(Data Migration Assistant). The Data Migration Assistant (DMA) which is a free tool from Microsoft. DMA helps us to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. DMA recommends performance and reliability improvements for your target environment and allows you to move your schema, data, and uncontained objects from your source server to your target server. The DMA assessment workflow detects Migration blocking issues,Partially supported or unsupported features,compatibility issues (Breaking changes,Behavior changes,Deprecated features) and suggests feature recommendations(Performance,Security,Storage). References :- https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-2017 https://channel9.msdn.com/Shows/Data-Exposed/First-Look-at-the-new-SQ