Enhanced SQL Migration Tracking & Bringing SQL Server Arc Assessments to Azure Data Studio
In the ever-evolving landscape of data management, ensuring seamless and efficient migrations is crucial for businesses. Migration is a multi-step process and typically requires multiple tools to complete the migration. To enhance the migration experience, we are bringing a new feature that enhances the migration tracking experience across tools. In this blog post we delve into the benefits this feature offers to streamline the migration tracking process. This feature is available for Azure Data studio users via the latest Azure SQL Migration extension v1.5.8 The Azure SQL migration extension now offers 2 new features in ADS to help users in their migration journey. Ability to view Arc assessments, SKU recommendation in Azure Data Studio Ability to track the migration via SQL Server instance (At no additional cost!) Viewing Arc assessments in Azure Data Studio for SQL Server enabled by Azure Arc If you are planning to migrate SQL Server instances that are Arc-enabled, The Azure Data studio now helps you jump start the migration by providing the ability to view the pre-computed Arc assessments. ADS now provides a link to the pre-computed assessments in the Arc experience Azure portal, which provides migration readiness assessment, SKU recommendation and pricing information (coming soon). Users can continue with rest of their migration journey in the Arc experience. To view the pre-computed assessments computed by Arc, users have to select Yes to the ‘Is your SQL Server instance tracked in Azure? ‘and fill in the Azure resource details of the SQL Server Instance enabled by Azure Arc. The pre-computed assessments and SKU recommendations will be generated as a navigation link to users like below: Ability to streamline the migration tracking process For SQL Server instances which are not Arc-enabled, this feature provides an ability to track the migration by creating an Azure resource with no additional cost associated. Once this resource has been created, users can select this migration resource which is created for their successive migrations that take place for the same source & avail the assessment and readiness benefits. This migration tracking ability is available for both Azure Data Studio and Database migration service portal. Below images show the experience for this ability in Azure DMS portal:Leverage GitHub Copilot to work with MySQL in Azure Data Studio
GitHub Copilot is an AI-powered code completion tool developed by GitHub and powered by OpenAI. It leverages machine learning models trained on vast amounts of code to generate context-aware code suggestions to make you more productive. If you’re a developer wanting to learn MySQL or to improve your productivity while developing with MySQL, then GitHub Copilot on Azure Data Studio can help you get started.Introducing Azure SQL Database offline migrations for the Azure SQL migration extension
The new migration capability in the Azure SQL Migration extension provides an end-to-end experience to modernize SQL Server to Azure SQL Database. The extension allows you to perform a migration readiness check with actions to remediate possible migration blockers, export the assessment results, and get right-sized Azure recommendations.Announcing MySQL extension for Azure Data Studio (Public Preview)
We're excited to announce a new MySQL extension for Azure Data Studio! You can use this extension to connect to, query and develop for MySQL hosted on-premises or on the cloud (on VMs, on managed MySQL in other clouds or on Azure Database for MySQL – Flexible Server), using the capabilities of Azure Data Studio.Azure Data Studio - default dashboard settings for Server and Desktop?
Hello. I am just starting to learning Azure Data Studio. My Server Dashboard and Database Dashboard don't seem to have the same widgets by default as per all of the tutorials. Below are my default settings (which have not changed). Could someone please tell me (or perhaps provide) the default settings I need so that my dashboards display all of the "default" widgets? { "workbench.enablePreviewFeatures": true, "workbench.startupEditor": "welcomePageWithTour", "datasource.connectionGroups": [ { "name": "ROOT", "id": "C777F06B-202E-4480-B475-FA416154D458" } ], "datasource.connections": [ { "options": { "connectionName": "", "server": "localhost\\SQLEXPRESS", "database": "", "authenticationType": "Integrated", "user": "", "password": "", "connectTimeout": "30", "connectRetryCount": "1", "connectRetryInterval": "10", "applicationName": "azdata", "groupId": "C777F06B-202E-4480-B475-FA416154D458", "databaseDisplayName": "" }, "groupId": "C777F06B-202E-4480-B475-FA416154D458", "providerName": "MSSQL", "savePassword": true, "id": "e53c9395-7bd0-4864-b65c-01ad39fbf340" } ], } PS: I couldn't find a specific topic group for "Azure Data Studio". If this is not the correct place, please let me know where best to ask my question. Many thanks Michelle
