Microsoft database migration tools

There are various Microsoft tools that you can use to help you migrate your database:

Data Migration Assistant (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 and Azure SQL Database.  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.  Download version 3.1

Database Experimentation Assistant (DEA) – is a new A/B testing solution for SQL Server upgrades.  It will assist in evaluating a targeted version of SQL for a given workload.  Customers who are upgrading from previous SQL Server versions (SQL Server 2005 and above) to any new version of the SQL Server will be able to use these analysis metrics provided, such as queries that have compatibility errors, degraded queries, query plans, and other workload comparison data, to help them build higher confidence, making it a successful upgrade experience.  Download technical preview 2

In short, customers will be able to access and upgrade their databases using DMA, and validate target database’s performance using DEA.

SQL Server Migration Assistant (SSMA) –  for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2 and Access lets users convert database schema to Microsoft SQL Server schema, upload the schema, and migrate data to the target SQL Server.  Download version 7.3

Also worth mentioning is in Azure Data Factory, where you can use the Copy Activity to copy data (not schema) of different shapes from various on-premises and cloud data sources to Azure.  See Move data by using Copy Activity.

More info:

PASS Summit Announcements: DMA/DEA

Migrate from on-prem SQL server to Azure VM IaaS

Migrate from on-prem SQL server to Azure SQL Database

Getting data into Azure Blob Storage

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in SQL Server, SQLServerPedia Syndication. Bookmark the permalink.

3 Responses to Microsoft database migration tools

  1. Vijayakumar N says:

    Hi,

    Apart from SQL Database engine assessment, will this Data Migration Assistant (DMA) do assessment on assessment on Analysis services, integration services and reporting services as well?.
    In this case, I find SQL upgrade adviser for 2012 and 2014 is more helpful as it can assess all relevant SQL Services installed on a machine.

    Thanks in advance

    • Harini Gupta says:

      Hi Vijayakumar,

      DMA currently only supports assessments on DB engine. We are working to add support to AS, RS, IS at a future time.

      Apologies for the inconvenience.

  2. Rathish V says:

    Hi,

    I am playing with DMA 3.1 Version.
    In specify source&target tab(Migration type) i couldn’t able to proceed with instance named connection (ex ip\SQLDEV2016). if i give source or target server connection, DMA shows ‘Unable to determine default values for target server.No such host is known’ but i can able to connect through SQL engine.

    Thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *