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

Blog: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-cloud-migrate

Data Migration Assistant

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

•Detects:

•Migration blocking issues

•Partially or unsupported features and functions

Blog: https://blogs.msdn.microsoft.com/datamigration/dma/

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

Blog: https://blogs.msdn.microsoft.com/datamigration/2016/12/22/released-sql-server-migration-assistant-ssma-v7-2/

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

Blog: https://docs.microsoft.com/en-us/azure/data-factory/data-factory-azure-copy-wizard

SQL Database Migration wizard

•Can be useful for validation

Source: https://sqlazuremw.codeplex.com/

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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s