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

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

After that run the wizard as below

 

Select “Script entire database and all database objects”

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

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

And also choose

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

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. Done

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

Namoskar!!!