Having migrated a few of our on premise databases over to AzureSQLDB I’ve always found it a little painful or very painful depending on the method you’ve decided to use.
The above graphic illustrates two common methods used to migrate & convert a database from an on premise SQL instance into an AzureSQLDB, I tended to use the Bacpac method (to the left) which wasn’t too bad, but still wished it could be a little easier.
Well in true Truman show style, someone at Microsoft must of heard my wishes and in SSMS (SQL Server management studio) 2016 they’ve now made this process as simple as a few clicks (and long wait depending on the size of the database)
Here how it works
Firstly we need to log onto the on premises SQL instance which currently hosts the database you want to migrate to an AzureSQLDB
Right click on the database – Tasks and then select the option highlighted in the picture below
Then connect to the Azure SQL database instance (you must have a SQL database instance created to carry this function out). At this point you can also change the name of the database if you wanted by changing the text box New database name otherwise this will default to the current database name and finally select the temporary area where the bacpac will be created for the migration, this automatically defaults to a temp area but you can also change this if required.
Click next and it will show you a summary of what has been configure and then hit the finish button and sit back.
Once completed (which can take sometime depending on the size for the database and data) you will be presented with and operation complete page.
Now if I log onto my SQL Server instance in Azure I’m able to see the newly migrated database.
So as you can see, this process is similar to the bacpac (which is still required) method , but it now carries out these steps for you.
Hope this helps