The Azure SQL migration extension for Azure Data Studio enables you to assess, get right-sized Azure recommendations and migrate your SQL Server databases to Azure.
The Azure SQL Migration extension for Azure Data Studio offers these key benefits:
A responsive UI for an end-to-end migration experience. The extension starts with a migration readiness assessment and SKU recommendation (preview) (based on performance data).
An enhanced assessment mechanism that can evaluate SQL Server instances. The extension identifies databases that are ready to migrate to Azure SQL targets.
Note
You can use the Azure SQL Migration extension to assess SQL Server databases running on Windows or Linux.
An SKU recommendation engine that collects performance data from the on-premises source SQL Server instance and then generates right-sized SKU recommendations based on your Azure SQL target.
A reliable Azure service powered by Azure Database Migration Service that orchestrates data movement activities to deliver a seamless migration experience.
You can run your migration online (for migrations that require minimal downtime) or offline (for migrations where downtime persists throughout the migration) depending on your business requirements.
You can configure a self-hosted integration runtime to use your own compute resources to access the source SQL Server instance backup files in your on-premises environment.
Provides a secure and improved user experience for migrating TDE databases and SQL/Windows logins to Azure SQL.
For information about specific migration scenarios and Azure SQL targets, see the list of tutorials in the following table:
Migration scenario Migration mode SQL Server to Azure SQL Managed Instance Online / Offline SQL Server to SQL Server on an Azure virtual machine Online / Offline SQL Server to Azure SQL Database OfflineThe following video explains recent updates and features added to the Azure SQL Migration extension for Azure Data Studio:
This article describes installing the Azure SQL migration extension through Azure Data Studio.
PrerequisitesIf you don't have an Azure subscription, create a free Azure account before you begin.
The following prerequisites are also required to install this extension:
Install the Azure SQL migration extensionFollow these steps to install the Azure SQL migration extension in Azure Data Studio. You can choose the standard installation method, or an offline mode when the computer is disconnected from the Internet.
Connected mode installationOpen the extensions manager in Azure Data Studio. You can either select the extensions icon or select Extensions in the View menu.
Type in Azure SQL Migration in the search bar.
Select the Azure SQL Migration extension and view its details.
Select Install.
You can see the Azure SQL migration extension in the extension list once installed.
You can connect to the SQL Server instance in Azure Data Studio. Right-click the instance name and select Manage to see the dashboard and the Azure SQL Migration extension landing page.
You can check for updates to the extension and have them automatically updated by configuring Auto Update in Azure Data Studio settings.
To enable auto updates:
Select the Settings icon in Azure Data Studio.
Select the checkbox under User > Features > Extensions > Auto Check Updates.
Select the dropdown under User > Features > Extensions > Auto Update and select either All Extensions or Only Enabled Extensions.
Note
If you want to update the extension manually, you can disable Auto Update and install the updates from the extension in the Marketplace.
Download installation filesTo install the Azure SQL migration extension on a disconnected computer, you must manually download Azure Data Studio, the Azure SQL migration extension VSIX file, and the SQL tool service binaries, on a machine connected to the Internet, and then copy the file to the disconnect machine.
Download Azure Data Studio for the disconnected machine, from Download and install Azure Data Studio, and take note of the platform.
Download the latest Azure SQL migration extension VSIX file from the following location: https://sqlopsextensions.blob.core.windows.net/extensions/sql-migration/sql-migration-1.5.4.vsix.
Note
You can change the version number, which is 1.5.4 in this example, if you download a later version.
Download the required SQL tool service binaries. Follow this step after you install the Azure SQL migration extension on your disconnected machine.
On the disconnected machine, open the following path:
%USERPROFILE%\.azuredatastudio\extensions\microsoft.sql-migration-1.5.4
Note
You can change the version number, which is 1.5.4 in this example, if you download a later version.
Open the config.json file to find the version number for SQL tool service binaries to be downloaded. For example:
"version": "4.12.0.4"
Visit the releases tab of the GitHub repository using this version number. For example, https://github.com/microsoft/sqltoolsservice/releases/tag/4.12.0.4.
Depending upon the disconnected machine platform, download the Microsoft.SqlTools.Migration zip file. For example:
Microsoft.SqlTools.Migration-win-x64-net7.0.zipMicrosoft.SqlTools.Migration-win-x86-net7.0.zipCopy the three files you downloaded, to the disconnected machine where you want to run Azure Data Studio.
Install Azure Data Studio.
To install the Azure SQL migration extension, open Azure Data Studio and navigate to File > Install Extension from VSIX package. Locate the VSIX file you copied to the disconnected machine.
On the disconnected machine, navigate to the following path:
%USERPROFILE%\.azuredatastudio\extensions\microsoft.sql-migration-1.5.4
Note
You can change the version number, which is 1.5.4 in this example, if you download a later version.
Create folders in the path to add the following subdirectories: \migrationService\windows\4.12.0.4\. Your folder structure should look similar to the following example:
%USERPROFILE%\.azuredatastudio\extensions\microsoft.sql-migration-1.5.4\migrationService\Windows\4.12.0.4
Note
You can change both the version number (which is 4.12.0.4 in this example) and platform (which is windows in this example), to match the version and platform downloaded the previous steps.
Extract the zipped Microsoft.SqlTools.Migration file under the above mentioned path.
Restart Azure Data Studio.
The Azure SQL migration extension supports assessment and generates Azure recommendations (Preview) and database migrations for the following Azure SQL targets.
The SQL migration extension in Azure Data Studio enhances SQL migration tracking, by displaying precomputed Arc assessments and SKU recommendations for SQL Server instances enabled by Azure Arc. For non-Arc enabled SQL Server instances, you can track the migration process in the Azure portal at no additional cost.
Migration modesThe following migration modes are supported for the corresponding Azure SQL targets.
Migration mode Description Online The source SQL Server database is available for reading and writing activity, while database backups are continuously restored on target Azure SQL. Application downtime is limited to the duration of the cutover at the end of migration. Offline The source database can't be used for writing activity while backup files are restored on the target Azure SQL database. Application downtime persists from the start until the completion of the migration process. Support matrix Get help from Microsoft supportYou can raise a support request to get Microsoft support assistance if you encounter issues or errors with your database migrations using the Azure SQL migration extension.
Select the New support request button in the upper section of the extension. It automatically takes you to the Azure portal, where you can fill in the details and then submit a support request.
You can submit ideas/suggestions for improvement, and other feedback, including bugs, in the Azure Community forum - Azure Database Migration Service. You can also use the Feedback button if you have any suggestions or feedback to improve the extension.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4
