Azure dataplatform also provides Azure SQL database as a relational database as a service PAAS which is fully managed by Microsoft.This helps the developers to build their apps very quickly and removes the overhead of database administration.
There are few methods to migrate an on premise SQL database to Azure SQL Database and in this article we will have a look at migrating them with two options.
1) Using BACPAC export and import.
2) Data Migration Assistant.
Using BACPAC export and import:
With BACPAC export and import firstly we need to export the SQL database from the on premise SQL instance as a data tier application.
To export – Open SQL Management Studio – Right Click on the desired database and click on tasks – select export data tier application.Continue reading