How to move or migrate SQL database from one azure VM to another azure VM RRS feed

  • Question

  • Hi all,

    I am trying to upgrade or migrate SQL database (2008R2) which is in one azure virtual machine to SQL database 2016 which is in another azure virtual machine . I could take a .bak file from the source vm and place it into the destination vm and restore it. But i am not able to use copy database wizard since i couldn't  connect the destination instance from source. Can anyone please help he how to achieve this

         Also can you let me know how to connect the sql server instance in a azure vm from onpremise sql server instance.

    Thanks in Advance...

    • Edited by Eforc Tuesday, August 2, 2016 6:43 AM
    Tuesday, August 2, 2016 6:31 AM