Migrating to Azure SQL Managed Instance from SQL 2017

• DanielP

  SSCrazy

  Points: 2321

  More actions

  October 2, 2020 at 2:15 am

  #3792415

  Hello,

  Do you have to use 'Azure Database Migration Service' to migrate to Azure SQL Managed Instance from a SQL 2017 VM in Azure?  Or can you just do a backup and restore using Credentials and backing up to Azure blob storage and restoring?  I took the backup and restore approach and it worked just fine.  I already ran the Database Migration Assistance and fixed any issues found.  I then scripted and migrated Logins, Operators, SQL Jobs, etc.

  I guess my question is what is the advantage to using 'Azure Database Migration Service' - having the GUI?

  Thanks,

   

  Daniel

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 3, 2020 at 3:10 am

  #3792651

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• November 17, 2020 at 2:36 pm

  This was removed by the editor as SPAM

• March 17, 2021 at 4:11 am

  This was removed by the editor as SPAM

• Ivyran

  Newbie

  Points: 2

  More actions

  July 20, 2022 at 12:20 pm

  #4065893

  On the other hand besides the info provided via Benwalker , instead of using Azure Database Migration Service, you can use tools like Sharegate, Gs Richcopy 360, or Goodsync to migrate the database automatically and easily with just a few steps to Azure

• September 6, 2022 at 6:44 am

  This was removed by the editor as SPAM