Month: March 2019

First published on MSDN on Oct 16, 2018
Authored by nesin@microsoft.com
 
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 err… Continue reading Troubleshooting MySQL online migration failure in DMS→

First published on MSDN on Oct 16, 2018

Authored by rajpo@microsoft.com

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 uncontained objects from your source server to your target server. DMA replaces all previous versions of the SQL Server Upgrade Advisor (SSUA) and should be used to upgrade most versions of SQL Server (see below for supported versions).

What’s new in v4.1?

The v4.1 release of DMA introduces support for comprehensive assessment of migrating on-premises SQL Server databases to Azure SQL Database Managed Instance.

The assessment workflow helps you detect the following issues, which can affect your migration to Azure SQL Database Managed Instance:

Unsupported or partially supported features . DMA assesses your source SQL Server database for features in use that are partially supported or unsupported on the target Azure SQL Database Managed Instance. The tool then provides a comprehensive set of recommendations, alternative approaches available in Azure, and mitigating steps so that customers can take this information into account when planning their migration projects.

DMA also identifies compatibility issues related to the following areas:

• Breaking changes:  The specific schema objects that may break the functionality migrating to the target database.  We recommend fixing these schema objects after the database migration.

• Behavior changes: The schema objects reported may continue to work, but they may exhibit a different behavior, for example performance degradation.

• Informational issues:  These objects will not impact the migration but may have been deprecated from feature SQL Server releases.

After the assessment is complete, use our Azure Database Migration Service (DMS) to perform the migration of your SQL Server databases to Azure SQL Database Managed Instance.  DMS supports both offline (one-time) and online (minimal-downtime) database migrations to Azure SQL Database Managed Instance.

Watch our short video How to assess on-premises SQL Server migrating to Azure SQL Database Managed Instance using DMA.

[video width="1154" height="720" mp4="https://msdnshared.blob.core.windows.net/media/2018/10/DMAAssessMI.mp4"][/video]

Supported source and target versions

Sources : SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017 on Windows.

Targets : SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 on Windows and Linux, Azure SQL Database and Azure SQL Database Managed Instance.

Installation

You can install the tool from Microsoft Download Center . Run the DataMigrationAssistant.msi file to install the Data Migration Assistant.

Resources

• Data Migration Assistant documentation

• Video: Assess on-premises SQL Server databases using DMA

• Migrate SQL Server to Azure SQL Database Managed Instance offline using DMS

• Migrate SQL Server to Azure SQL Database Managed Instance online using DMS

• Video: Migrate online to Azure SQL Database Managed Instance using Azure DMS

• Database Migration Guide

• Azure Database Migration Service (DMS)

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

First published on MSDN on Oct 04, 2018
Authored by scphang@microsoft.com
Recently we announced many exciting online migration scenarios which enable customers to perform migrations with source databases continue to be operational, and hence m… Continue reading Expanding to more Azure regions for online migration→

First published on MSDN on Sep 24, 2018
Authored by rajpo@microsoft.com
Today, we are very excited to announce general availability of offline migrations and public preview availability of online migrations to Azure SQL Database Managed I… Continue reading Announcing General Availability of Azure SQL Database Managed Instance Migration in Azure Database Migration Service→

First published on MSDN on Sep 21, 2018
Authored by npatel@microsoft.com
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… Continue reading Announcing Preview of MongoDB migrations to Azure Cosmos DB MongoDB API using Azure Database Migration Service→

First published on MSDN on Sep 19, 2018
Authored by harinid@microsoft.com
The Azure Database Migration Engineering Team, represented by Raj Pochiraju ( @rajpochiraju ) and Shamik Ghosh( @g_shamik ), will host multiple workshops and be speaking … Continue reading Join the Azure Database Migration Engineering Team at Microsoft Ignite→

First published on MSDN on Sep 19, 2018
Authored by harinid@microsoft.com
The Azure PostgreSQL (@AzureDBPostgres ) and MySQL (@AzureDBMySQL ) Engineering team, represented by Sudhakar Sannakkayala ( @sudhakars ), Sunil Kamath ( @kamathsun )… Continue reading Join the Azure Open Source Database Engineering Team at Microsoft Ignite→

First published on MSDN on Sep 12, 2018
Authored by datamigrationteam@microsoft.com
We are pleased to announce public preview availability of online migration in Azure Database Migration Service (DMS). Azure DMS represents a single service that… Continue reading Public Preview Availability of PostgreSQL Online Migration in Azure Database Migration Service→