Introduction

The Microsoft SQL Server migrate both your schema and your data from the SQL Server database in your current environment into SQL Database, provided the existing database passes compatibility tests.

Data Migration Assistant to Moving your SQL Server database to an Azure SQL Database single database is as simple as creating an empty SQL database in Azure and then using the Data Migration Assistant (DMA) to import the database into Azure.

Prerequisites

  • SQL Server Management Studio (SSMS)
  • Data Migration Assistant (DMA)

SQL Server Migration Assistant Supported Sources and Target Versions

  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • Azure SQL Database
  • SQL Server 2017 on Windows and Linux
  • Azure SQL Data Warehouse

Installed the newest version of the Data Migration Assistant (DMA).SQLMDB.jpg