{"id":50868,"date":"2024-09-12T08:00:00","date_gmt":"2024-09-12T15:00:00","guid":{"rendered":""},"modified":"2024-09-12T08:43:27","modified_gmt":"2024-09-12T15:43:27","slug":"modernize-your-database-with-the-consolidation-and-retirement-of-azure-database-migration-tools","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2024\/09\/12\/modernize-your-database-with-the-consolidation-and-retirement-of-azure-database-migration-tools\/","title":{"rendered":"Modernize your database with the consolidation and retirement of Azure Database Migration tools"},"content":{"rendered":"\n

Simplifying Database Migrations with Azure SQL <\/h2>\n\n\n\n

By migrating their databases to Azure, customers like Ernst and Young are modernizing their data estate<\/a> and leveraging cutting-edge cloud innovations. However, the migration process can be complex, whether moving within the same database management system (homogeneous) or between different systems (heterogeneous). Microsoft offers a suite of tools for migration to simplify the migration process. To further enhance the user experience, we are streamlining the Azure database migration tools ecosystem. This involves retiring certain overlapping tools to simplify finding the right tool and provide unified migration experiences across all phases of migration. As part of this effort, effective 12\/15\/2024 we are replacing some tools with unified experiences<\/em><\/strong> that offer capabilities across various migration stages in the drive to modernize their data estate and take advantage of innovation in the cloud.<\/p>\n\n\n

\n\t
\n\t\t
\n\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\"man\t\t\t\t<\/div>\n\t\t\t\n\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\n\t\t\t\t\t

Azure Database Migration Guides<\/h2>\n\n\t\t\t\t\t
\n\t\t\t\t\t\t

Step-by-step guidance for modernizing your data assets<\/p>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\tLearn more<\/span>\n\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

With a refined set of tools, you can confidently plan, assess, and execute your database migration with minimal downtime, ensuring a smooth transition to Azure SQL. Post the 12\/15\/24, retirement date, Microsoft will stop supporting these tools for any issues that arise and will not issue any bug fixes or further updates.<\/strong> Here is the list of tools that are planned for retirement and Microsoft recommended replacement tools.<\/p>\n\n\n\n

Tool<\/th>Retirement Date <\/th>Recommend replacement<\/th><\/tr><\/thead>
Database Migration Assessment for Oracle (DMAO)<\/a> is an extension in Azure Data Studio that helps you assess an Oracle workload for migrating to Azure SQL and Azure Database for PostgreSQL. <\/td>12\/15\/2024 <\/td>For Azure SQL target assessments switch to using assessment and Azure SQL target recommendation capabilities in SQL Server Migration Assistant (SSMA)<\/a> for performing Oracle to Azure SQL assessments in your migration journey to Azure SQL. For PostgreSQL target assessments switch to using Ora2PG Migration cost assessment<\/a> capabilities to get Azure PostgreSQL target recommendations. <\/td><\/tr>
Database Schema conversion Toolkit (DSCT)<\/a> is an extension for\u202fAzure Data Studio\u202fdesigned to automate database schema conversion between different database platforms.<\/td>12\/15\/2024 <\/td>Switch to using conversion assessment<\/a> and converting Oracle Schemas<\/a> capabilities in SQL Server Migration Assistant (SSMA)<\/a> for Oracle to Azure SQL conversions in your migration journey to Azure SQL.<\/td><\/tr>
Database Experimentation Assistant (DEA)<\/a> is an experimentation solution for SQL Server upgrades. DEA can help you evaluate a targeted version of SQL Server for a specific workload. <\/td>12\/15\/2024 <\/td>Use open-source tools like SQLWorkload<\/a>, which is a collection of tools to collect, analyse and replay SQL Server workloads, on premises and in the cloud.<\/td><\/tr>
Data Access Migration Toolkit (DAMT)<\/a> is a VS Code extension that help users identify SQL code in application source code when migrating from one DB to another and identify SQL compatibility issues. Supported source database backends include IBM DB2, Oracle Database and SQL Server. <\/td>12\/15\/2024 <\/td>For identifying the SQL queries in source code, our recommendation is to use Regex or parse the application code either manually or with custom-built tools to identify T-SQL embedded in the application code. For identifying compatibility between your source SQL Server and the target Azure SQL, please use assessment capabilities available in SQL Server enabled by Arc or Azure SQL Migration extension for Azure Data Studio or using Azure Migrate SQL Assessment capabilities. <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Homogenous migrations (SQL Server to Azure SQL) <\/h2>\n\n\n\n

If the SQL Server that will be migrated is already enabled by Azure Arc, you can use Arc capabilities to perform a migration assessment and get optimal Azure SQL Target recommendations. Additionally, SQL Server enabled by Azure Arc provides multiple Azure benefits to SQL Servers outside Azure like automated backups and patching, Microsoft Defender for SQL<\/a>, inventory of instances and databases, and Entra ID support. By enabling these Arc features, you can leverage cloud automation and security for Azure SQL Server even before you migrate. <\/p>\n\n\n\n

If the SQL Server outside Azure is not inventoried yet, you can use Azure Migrate<\/a> for discovery<\/a>, assessment<\/a> and business case<\/a> to know the right Azure SQL targets for your on-premises SQL Workloads and to get the projected cost savings of migrating to Azure SQL.<\/p>\n\n\n\n

To migrate SQL Server into an Azure Virtual Machine with the same configuration as the source, users can use Azure Migrate to perform lift and shift migrations. SQL Server on Azure Virtual Machines allows you to easily migrate your SQL Server workloads to the cloud, offering SQL Server’s performance and security along with Azure’s flexibility and hybrid connectivity to address urgent business needs. Later you can evaluate one of the Azure SQL PaaS targets (Azure SQL Managed Instance, Azure SQL Database) and modernize to a PaaS service for better cost and workload performance optimizations. <\/p>\n\n\n\n

If you have completed an assessment and are ready to move to Azure SQL Managed Instance or Azure SQL Database<\/a>, you can start your migration journey with Azure Migrate, you can use Azure Database Migration service<\/a> or <\/strong>Azure SQL Migration extension<\/a> for Azure Data Studio can be used. <\/p>\n\n\n\n

If the SQL Server estate is already inventoried, users can use Azure SQL Migration extension for Azure Data Studio<\/a> to complete the entire migration journey i.e., perform assessment, get Azure SQL Target recommendations and perform migrations.<\/p>\n\n\n\n

Heterogenous migrations (non-SQL Server databases to Azure SQL) <\/h2>\n\n\n\n

With the availability of Target Assessment and SKU recommendation capabilities in SQL Server Migration Assistant (SSMA)<\/a> along with existing code conversion and migration capabilities, SSMA becomes a single tool that you need to use to migrate from other source database platforms like Oracle, DB2, SAP ASE, MySQL, Access to Azure SQL or SQL Server. <\/p>\n\n\n\n

Learn more about modernizing your databases with Azure<\/h2>\n\n\n\n