We're delighted to announce the release of the latest version of the Azure SQL Migration extension for Azure Data Studio, v1.5.6.
This release provides you with Azure Database Migration Service’s new features like:
1) Support for Next-gen General Purpose service tier for Azure SQL Managed Instance.
2) Target Provisioning based upon SKU recommendation (using ARM templates) - Public Preview.
3) Enhanced login migration experience - Public Preview.
What is new in Azure SQL Migration extension v1.5.6?
1) Support for Next-gen General Purpose service tier for Azure SQL Managed Instance:
The Next-gen General Purpose service tier is an architectural upgrade to the existing General Purpose service tier that can be used for new and existing instances. Now, the Azure Data Studio extension for Azure Database migration service – Azure SQL Migration support Next-gen General Purpose as SKU recommendation for Azure SQL Managed Instance. For details, refer here.
This service tier provides better performance, throughput, greater storage capacity and support more than 100 databases on a single instance.
2) Target Provisioning based upon SKU recommendation (using ARM templates) - Public Preview:
With Azure SQL Migration v1.5.6, now users can generate ARM templates directly based upon the SKU recommendation generated using performance data collected from the source. User can use these ARM templates for all the Azure SQL offerings – Azure SQL VM, Azure SQL MI and Azure SQL DB and easily create the Azure SQL Target for the migrations.
To create and deploy the Azure SQL Target, users have two options:
- a) Copy or save the ARM template in JSON and use Azure CLI, PowerShell and other deployment operations.
- b) Using Deploy-to-Azure button, then provide the Azure blob storage account details to store the template and deploying it though the Azure Portal.
This feature is in Public Preview and will help you to streamline the Azure SQL target creation using ARM templates, can automate deployments and use the practice of infrastructure as code, deploy them quickly and CI/CD integration.
3) Enhanced login migration experience - Public Preview:
After completing the data migration, the next critical step is to setup the authentication and authorization for the databases and thus login migration becomes the critical step in the migration journey.
Azure SQL Migration extension supports Login migration (Public Preview) and now we have enhanced its experience by adding Pre-requisites validation checks to ensure all the requirements are in place for successful login migrations.
Currently, only Azure SQL Managed Instance and SQL Server on Azure Virtual Machines targets are supported.
Resources
For more information about the extension and Azure Database Migration Service, see the following resources.
Microsoft
