Azure SQL Migration Tools

In preparing a presentation for data migration to Azure, thought I’d share some of my research. There are other methods not specified here, but this should be a good start! Each toolset includes notes about that tool, and where to find it.

SQL Server Management Studio – Migration Wizard

•Built into core SSMS


Data Migration Assistant

•Enables assessment of your on-premises SQL Server instance migrating to Azure SQL databases


•Migration blocking issues

•Partially or unsupported features and functions


SQL Server Migration Assistant

•Supports migration 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


Azure Data Factory Copy Wizard

•Data Factory is a cloud-based data integration service that orchestrates and automates the movement and transformation of data

•Can be incredibly fast


SQL Database Migration wizard

•Can be useful for validation


This entry was posted in Azure SQL Server, Migration, SQL Server and tagged , . Bookmark the permalink.

1 Response to Azure SQL Migration Tools

  1. Chris Randle says:

    SQL Azure Migration Wizard is replaced with the Data Migration Assistant (DMA)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.