I have two SQL AZURE databases on same server.

Need to move data from table (database 1) to another table (Database 2) using INSERT INTO. See below

INSERT INTO Database1.Table1

SELECT * FROM Database2.Table1
I can't use Azure Sync feature in my scenario.
Please suggest something.

Thanks,

Hi Hema,

Cross Database query is yet not available as part of Azure SQL Database. The reason being, even if multiple DBs are lying in one logical server on Azure SQL, but they might not be one physical server.

With Elastic Database Query, currently you can use only SELECT statements on remote database, however INSERT INTO operations are yet not supported.

In your scenario, is it possible to use the remote database as the one from where you read the data (only use SELECT statements), and INSERT INTO local database? 

I would love to learn about your scenario, can you please share your feedback with the team using this short <5 min survey: http://www.instant.ly/s/PTdK