Moving On-premises SQL Server Database to SQL Azure

Is very easy and can’t think of anything simple. I did it with my favorite TestDB database Smile

Open SQL Server Management Studio. Right click the database and select Generate Script

image

After that run the wizard as below

image

 

image

Select “Script entire database and all database objects

image

Select “Save to new query window” and click advanced.

image

NoteChoose the property value of “Script for the database engine type” to “SQL Azure Database

And also choose

image

Choose the property “Types of data to Script” to “Schema and data”. This would bring data along with the schema.

image

Now hit next and finish.

Note: If you have any table which has no clustered index then you will not be able to import them to SQL Azure.

Now you need to create a database at your SQL Azure (through Portal) and run the script from your SQL Management Studio. DoneSmile

You could also use SSIS and BCP to do the same. But this one is the easiest to me.

Namoskar!!!