Another way to move SQL DB to Azure

About 8 months ago I wrote an article (http://www.sqlservercentral.com/articles/SQL+Server/139998/ ) where I showed you how to migrate your “earth” SQL Database to Azure using a BACPAC import. If you look at the following diagram I will now show you the middle route of migration using the deployment wizard.

First you need to make sure that your local (earthed-based) database is V12 compatible and if not address those issues first else the migration will fail.

ape

Next connect to your local SQL Server database using a recent release of SQL Server Management Studio (the one that you want to migrate) and under tasks you will want to select “Deploy Database to Microsoft Azure SQL Database”.

ape2

Next you will need to make sure that you enter valid deployment settings for your target connection.

dasdasfsfsfasfsfwe

So once you have selected the connect button you will need to connect to your Azure SQL Server using your server admin account.

ape4

Back to the main screen you will then have the ability to change basic database settings such as edition and size.

ape6

Once you are happy with the details on the summary screen just click finish.

ape7

Naturally the time this process takes will depend on the amount of data you are moving and on what sort of connection you have to the Azure DC.

I like to confirm the migration went well, so I connected via SSMS to check for the existence of my database.

ape0

So now I have covered another way to move to Azure.

 

One thought on “Another way to move SQL DB to Azure

  1. Pingback: Another way to move SQL DB to Azure - SQL Server Blog - SQL Server - Toad World

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 )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s