locked
Merge statement between two SQL Azure databases hosted in same SQL azure server RRS feed

  • Question

  • Hi Team,

    Currently we have a SQL Virtual machine with two databases, namely Source_DB, Destination_DB (Both within in same SQL server).  And we have cross database merge statement to move data between them.

    We have planned to migrate to SQL Azure Database.   So, I will create a SQL Azure server and create Source_DB & Destination_DB  databases in this server.  Is there any good performance way to run merge statement between these two SQL Azure databases present in same SQL server?

    Regards,

    Kannan Eswar.


    Monday, May 29, 2017 5:56 AM

All replies