Azure SQL Database — database migration

I explained how to migrate data to an Azure database in the last post. Now, I show you how to migrate an entire database located in a SQL on-premise server to an Azure SQL Database.

The whole process is pretty easy. In SSMS, select a database which you want to migrate -> Tasks -> Deploy Database to Microsoft Azure SQL Database.

Specify destination properties like a connection, a database name for an Azure SQL database.

And this is the end.

Before exporting an existing database you can use a Microsoft Data Migration Assistant to examine if the database is valid to export.

An overview how to set parameters is located in the previous post.

The main difference is at the first step. You should pick an Assessment instead of a Migration.

You can check a feature parity…

…and compatibility issues.

Alternatively, you can export a bacpac file, put it into an Azure blob storage and import into a destination.