Database Migration Guide – October 2018 Updates

What’s new with the latest updates? The latest updates to the Database Migration Guide include: Launched a new and enhanced user interface that makes it easier to specify your migration scenario and that surfaces the most commonly used guides, which are available with a single click. Added/updated guidance for the following migration scenarios (source/target pairs):…


Release: SQL Server Migration Assistant (SSMA) v7.11

Overview SQL Server Migration Assistant (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 (see below for supported versions). What is new? Each iteration of the…


Troubleshooting MySQL online migration failure in DMS

Overview While performing an online migration of a MySQL database using the Azure Database Migration Service (DMS), a few of our customers have encountered a similar error message: “’load data local infile \”R:\\\\repldata\\\\tasks\\\\fd954e8d-5a57-48e0-93f8-af811246c0f8\\\\data_files\\\\1\\\\LOAD00000277.csv\” into table …;'”,”RetCode: SQL_ERROR SqlState: HY000 NativeError: 1213 Message: [MySQL][ODBC 5.3(w) Driver][mysqld-5.6.39.0]Deadlock found when trying to get lock; try restarting transaction”,”Failed to…


Announcing migration assessments for on-premises SQL Server to Azure SQL Database Managed Instance using DMA 4.1

Overview The Data Migration Assistant (DMA) provides a comprehensive assessment by detecting compatibility and functionality issues prior to migrating to a specific version of SQL Server, Azure SQL Database, or Azure SQL Database Managed Instance. The tool recommends performance and reliability improvements for your target environment. DMA allows you to move the schema, data, and…

0

Expanding to more Azure regions for online migration

Recently we announced many exciting online migration scenarios which enable customers to perform migrations with source databases continue to be operational, and hence minimize downtime needed during the daunting migration effort.  These migration scenarios include:- From SQL Server to Azure SQLDB online From SQL Server to Azure SQL DB Managed Instance online From MySQL to Azure Db for…

0

Announcing General Availability of Azure SQL Database Managed Instance Migration in Azure Database Migration Service

Today, we are very excited to announce general availability of offline migrations and public preview availability of online migrations to Azure SQL Database Managed Instance in the Azure Database Migration Service (DMS). The GA release significantly enriches this database migration scenario – you can use Azure DMS to migrate SQL Server databases running on-premises or…

0

Announcing Preview of MongoDB migrations to Azure Cosmos DB MongoDB API using Azure Database Migration Service

Azure Database Migration Service now supports migrations from MongoDB to Azure Cosmos DB MongoDB API. You can sign up for this preview capability here. Azure Cosmos DB is Microsoft’s globally distributed, multi-model database service for mission-critical applications. Azure Cosmos DB provides turn-key global distribution, elastic scaling of throughput and storage worldwide, single-digit millisecond latencies at…


Join the Azure Database Migration Engineering Team at Microsoft Ignite

The Azure Database Migration Engineering Team, represented by Raj Pochiraju (@rajpochiraju) and Shamik Ghosh(@g_shamik), will host multiple workshops and be speaking at several sessions at the Microsoft Ignite (@MSIgnite)conference next week from September 24th to 28th, 2018 in Orlando, FL, USA. The team will share guidance on how to seamlessly move your applications to Azure…

0

Join the Azure Open Source Database Engineering Team at Microsoft Ignite

The Azure PostgreSQL (@AzureDBPostgres) and MySQL (@AzureDBMySQL) Engineering team, represented by Sudhakar Sannakkayala (@sudhakars), Sunil Kamath (@kamathsun), Jan Engelsberg, Jean-Yves Devant (@jydevant), Harini Gupta (@gupta_harini), along with Database Migration Team members Raj Pochiraju (@rajpochiraju) and Shamik Ghosh (@g_shamik), will host multiple workshops and be speaking at several sessions at the Microsoft Ignite (@MSIgnite) conference held…

0

Public Preview Availability of PostgreSQL Online Migration in Azure Database Migration Service

We are pleased to announce public preview availability of online migration in Azure Database Migration Service (DMS). Azure DMS represents a single service that you can use for migrating data from different database engines to Azure with built-in resiliency and robustness. Using online migrations, businesses can migrate their databases to Azure while the databases continue…