Azure SQL Database data migration

A whole on-premise database export to Azure is pretty easy. What, if you want to move only a certain data or a schema, not an entire database. You can use the Microsoft Data Migration Assistant. Let’s assume, that we have three tables inside an on-premise database: an Airline, an Airport, a Flight and we want to move them into Azure (a schema and data).

Choose your source and a destination database type. In this case, the source is an on-premise SQL Server Database and the destination is an Azure SQL Database. You can choose following scopes:

• data
• schema
• data + schema

Select a source server and a database.

Choose a destination.

At the end, select objects which you want to export.

You can move other object types like functions, stored procedures, etc.

A further step shows T-SQL code responsible for the migration.

The migration starts in the next step. After this, all selected objects are migrated.