The following step-by-step instructions will help you to perform your first assessment migrating to either on-premises SQL Server or SQL Server running on Azure VM or Azure SQL Server database using DMA.
Create new assessment
- Click on the New(+) icon and select “Assessment” project type. Set the source and target server type to SQL Server if you intend to upgrade your on-premises SQL Server to a modern on-premises SQL Server or SQL Server hosted on Azure VM. Set the target server type to “Azure SQL Database” if you are migrating to Azure SQL Database.
- Click Create.
Choose assessment options
- Select the target SQL Server version that you plan to migrate to, and need to run assessment.
- You can choose one or both from the following assessment report types, when you are assessing your source SQL Server migrating to on-premises SQL Server or SQL Server hosted on Azure VM targets.
- Compatibility Issues
- New features’ recommendation
- You can choose one or both from the following assessment report types, when you are assessing your source SQL Server migrating to Azure SQL Database(s).
Add databases to assess
- Click on “Add Sources” to open the connection fly-out.
- Enter SQL server instance name, choose Authentication type and set the correct connection properties.
- Click “Connect”.
- Select the databases to assess and click “Add”.
- You can remove databases after you add them. Select multiple databases holding “shift” or “Ctrl” key, and click “Remove Sources”.
- You can add databases from multiple SQL Server instances using the “Add Sources” button.
- Click Next to start assessment.
- Assessment duration depends on the number of databases added and the schema size of each database.
- Results will be displayed per database as soon as they are available.
- Select the database that has completed assessment. Switch between “Compatibility issues” and “Feature recommendations” using the switcher.
- Review the compatibility issues across all compatibility levels supported by the target SQL Server version selected on the “Options” screen.
Compatibility Issues can be reviewed by analyzing the impacted object and its details for every issue identified under “Breaking changes”, “Behavior changes” and “Deprecated features”
- Similarly, you can review features’ recommendation across “Performance”, “Storage” and “Security” areas
Feature recommendations cover a variety of features such as In-Memory OLTP and Columnstore, Stretch Database, Always Encrypted (AE), Dynamic Data Masking (DDM), and Transparent Data Encryption (TDE).
- Assessments for “Azure SQL Database” provides, migration blocking issues and feature parity issues. Review the results for both categories by selecting the specific options.
- The “SQL Server feature parity” category provides, currently in use at the source SQL Server. It then provides comprehensive set of recommendations, alternative approaches available in Azure and mitigating steps so that customers can plan ahead this effort into their migration projects.
8. The “Compatibility issues” category, provides, partially or unsupported features that are the compatibility issues that block migrating on-premises SQL Server database(s)s to Azure SQL Database(s). It then provides recommendations to help customers remediate those issues.
Once all databases finish assessment, click on “Export report” to export the results to either JSON or CSV file for analyzing the data at your own convenience.
- You can run multiple assessments concurrently and view the state of the assessments from by navigating to the “All Assessments” screen.