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.