Assess your SQL Server databases for Azure SQL Managed Instance readiness or to identify any migration blockers before migrating them to Azure SQL Managed Instance.
Azure Data Studio is a unified tooling experience for data professionals. Designed to focus on the functionality data platform developers use the most, Azure Data Studio offers additional experiences available as optional extensions. It's built for data professionals who use SQL Server and Azure databases on-premises or in multicloud environments.
The Azure SQL migration extension for Azure Data Studio enables you to assess, get Azure recommendations and migrate your SQL Server databases to Azure SQL.
- SQL Server with Windows authentication or SQL authentication access
Caution
- Connect to the Jump Box VM
- VM name: jb-migration
- Use the credentials provided on the deploy page.
- Launch Azure Data Studio.
- Navigate to the "Extensions" tab located in the right-side menu.
- In the search bar, type "Azure SQL Migration" and press Enter.
- Locate the "Azure SQL Migration" extension from the search results.
- Click on the "Install" button next to the extension to begin the installation process.
After successfully installing the extension, follow these steps to connect to the SQL Server:
- Navigate to the "Connections" tab in the top menu.
- Click on "New Connection" to open the connection dialog.
- In the "Server" field, enter the following:
10.1.0.4 - Choose "Windows Authentication" as the authentication type.
- Set "Trust server certificate" to "True".
- Click "Connect" to establish the connection to the SQL Server.
After establishing the connection, the Manage page will appear.
- Go to the sidebar menu and select "General" to find the "Azure SQL Migration" extension.
- Click on the "Azure SQL Migration" extension to open it and begin using its features for migration tasks.
After accessing the home page of Azure SQL Migration, follow these steps:
- Look for the "+ New migration" button and click on it.
- Choose all databases that you want to include in the assessment.
- Click "Next" to proceed to the next step in the migration process.
- Click on the checkbox to select all databases available for assessment.
- Alternatively, individually check the checkboxes next to each database to select them manually.
- Once all databases are selected, proceed to the next step in the migration process.
- After a few minutes, a summary will appear, allowing you to review the assessment for Azure SQL targets.
- To begin collecting data from your databases to determine the best SKU, click on "Start Data Collection". This will initiate the data collection process.
- Alternatively, if you have already collected data, you can import it.
- You need to wait for approximately 10 minutes before you can start seeing recommendations.
- After this time, you'll be able to explore the SKU recommendations.
- To stop collecting data, click on "Stop Data Collection".
- When you click on "View Details," you'll access a detailed report for the SKU recommended.
- Additionally, you have the option to save the recommendation report.
After reviewing the SKU recommendation, click on the "Close" button to return to the summary page. From there, proceed by clicking "Next" to review any issues or blockers.
- Select "Azure SQL Managed Instance" as the target type.
- Navigate to the database named "AdventureWorksTDE".
- Click on the findings to view detailed information about the issues.
- Review issues or blockers for a specific database.
You can save your assessment and review it later.