Azure Arc enabled SQL Servers will perform weekly (if not explicitly disabled) assessments to review the SQL Servers for Azure compatibility and potential targets. This data is available within Azure but not directly exposed in the Azure portal. This tools aggregates that data to create a report for review of any potential migrations to SQL in Azure.
To run the assessments, the easiest method is to use Azure Cloud Shell.
- Go to https://shell.azure.com and switch to a PowerShell session
- Run
git clone https://github.com/cbattlegear/ArcSqlMigrationAssessmentAggregation.gitto copy the script to your cloud shell - Run
./ArcSqlMigrationAssessmentAggregation/AggregateAssessments.ps1to gather the assessment data - Download your assessment data using the path provided by the script in the "Manage Files" menu item
If you need more information about how to interpret the output, check out our documentation.
This assessment is a best effort analysis of your environment and is always beneficial if not suggested to further review these results and environment to ensure accuracy and applicability.
If any eligibility issues for any of the Azure SQL managed offerings or desire for a deeper assessments, a common tool for individual or small quantity of databases to use is Data Migration Assistant or for larger scale assessments Azure Migrate
