Migrate database to azure

• abdalah.mehdoini

  Ten Centuries

  Points: 1015

  More actions

  August 25, 2020 at 9:49 am

  #3783233

  Good morning all ,

  I have a 600GB database that I must transfer from an on-premises machine to an on Azure VM machine (iaas)

  I would like to use the dbatools copy-database tool for this

  for this I will have to know what will be the best storage method that allows me to have a fast transfer

  1 local backup then restore on the Azure machine

  2 remote backups directly on the machine in azure

  3 a backup and a restore from stoarge azure blob

  thank you for your advice

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  August 25, 2020 at 11:20 am

  #3783249

  I answered this over on stackexchange too. I'd use AZCopy to move the backups up to Azure Blob Storage, specifically where your VM has defined it's storage. Then, it's just a standard database restore. No tricks. Nothing weird. AZCopy is the fastest way I've seen for moving data up. If you move to multiple 10s of terrabytes, Microsoft has  service where you can ship them a drive, but you need to be a lot bigger than a few hundred gb to make that worth while.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning

• HardissonHard

  SSC Rookie

  Points: 45

  More actions

  September 4, 2020 at 9:26 am

  #3786223

  Oh, that is rather hard question

• September 4, 2020 at 12:42 pm

  This was removed by the editor as SPAM

• Jeff Moden

  SSC Guru

  Points: 1004363

  More actions

  September 4, 2020 at 2:31 pm

  #3786313

  TimWoods wrote:

  Before you publish your project to Azure App Service, you must first upload your project's database to Azure SQL Database.

  Heh... do tell... Just how would you accomplish such a thing or is this just generic typing to cover for the spam link in your signature line?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• July 2, 2023 at 1:09 pm

  This was removed by the editor as SPAM