Move data between two Azure SQL databases without using elastic query

Question

I am in need of suggestion to move data from a particular table in one azure sql database to the other azure sql database which has the same table structure without using elastic query

Answer 1

Using SQL Server Management Studio to connect to SQL azure database, right click the source database and select generate scripts.

During the wizard, after have select the tables that you want to output to a query window, then click advanced. About half way down the properties window there is an option for "type of data to script". Select that and change it to "data only", then finish the wizard.

The heck the script, rearrange the inserts for constraints, and change the using at the top to run it against my target DB.

Then right click on the target database and select new query, copy the script into it, and run it.

This will migrate the data.