First published on MSDN on Jul 16, 2018
Authored by datamigrationteam@microsoft.com
Since we announced General Availability of the Azure Database Migration Service (DMS) in May, we delivered a variety of new features and additional functionality to enhance and extend the value of this service and our other database migration tools. I am pleased to share with you some details about key deliveries we have made in each area.
Azure DMS is a fully managed service designed to enable seamless migrations from multiple database sources to Azure Data platforms with minimal downtime. Since we announced General Availability in early May, we have included the following updates:
DMA enables you to upgrade to a modern data platform by detecting compatibility issues that can impact database functionality on your new version of SQL Server. It recommends performance and reliability improvements for your target environment. It allows you to not only move your schema and data, but also uncontained objects from your source server to your target server.
We have recently released two minor updates to DMA, v 3.5 and v 3.6.
Version 3.6 introduces updates, including “Auto fix” for schema objects that are impacted by the most common migration blockers. With v3.6, auto-fix is enabled for the following migration blocker and behavior change issues:
DMA uses Microsoft Program Synthesis (PROSE) technology to suggest the code fixes. Learn more about PROSE at https://microsoft.github.io/prose/.
Version 3.5 introduces several updates, including:
SSMA for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server.
We recently release the latest minor update to SSMA, v 7.8, which includes the following changes:
DEA is a A/B testing solution for SQL Server upgrades that assists in evaluating a targeted version of SQL Server for a given workload. Customers upgrading from SQL Server 2005 and later to any new version of SQL Server can use the analysis metrics provided to help build with higher confidence for a successful upgrade experience.
The most recent release of DEA, v 2.5, provides the following improvements:
In addition, a few stability improvements have been included with this version of the tool.
If you are currently working with one of the tools or services, you might find the following links useful:
I hope that you enjoy working with the latest features and functionality available in our migration tools and services. Be sure to share your impressions through User Voice: Azure Database Migration Service , by using the feedback links at the bottom of each article in our documentation, or by reaching out to the Data Migration Team directly.
Regards,
Sudhakar Sannakkayala
General Manager
Azure Data – Data Magnet Team
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.