sql server - How to insert records from one SQL Azure Instance table to the same table but in another instance? -

i using sql azure.

i accessing , running db queries within ssms 2008.

i have 2 databases ie db1 , db2

i have table in db1 called "orders" in db2 , identical, lacks relevant orders transfer. not want copy pks across, these must generated db2.orders via in place identity pks.

i believe command looks like:

insert db2.orders select * db1.orders status = "complete" 

i appreciate confirmation of correct sql above.

thanks in advance.

sql azure doesn't support querying multiple databases together. can try if have on prem server running using linked server features selecting db1 , inserting db2.