Database Migration to AzureSQLDB using SSMS 2016

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.

oldmig

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

selecttoAzure

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.

Config

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.

OperationComplete

Now if I log onto my SQL Server instance in Azure I’m able to see the newly migrated database.

DatabaseMigrated

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

 

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s