0

I'm tying to transfer one sql database from one Azure account to another. One way to do this is documented by Microsoft here [Restore a Backup from a Device (SQL Server)], where they recomend to use BackUp and Restore options, but these options don't exist in my Task Menu:

enter image description here

I'm using SSMS V18.8 and the databases are hosted on Azure. Both source and destination server are in two different Azure accounts. I spent a lot of hours and didn't get a solution. Neither to show the options or using another way to transfer the database.

Marcelo Sader
  • 331
  • 4
  • 12
  • I haven't ever used any of the Azure SQL offerings, but being PaaS, aren't the backups managed for you? If so, is it possible that they remove the ability for you to take your own backups to avoid potentially disrupting their backup chain? – Ben Thul Jul 18 '22 at 14:53
  • I don´t think so, even when I access another database using ssms, these options aren't on menu. It seems like it is a kind of settings of ssms. But thank you @BenThul for the tip. This can be an alternative for the migration. I mean, actually, Azure offers backup management and maybe can be possible to migrate using the backup files generated om Azure. – Marcelo Sader Jul 21 '22 at 02:31
  • "when I access another database using ssms" - is that database also on Azure? What if you install Developer Edition on your workstation and try to backup a database. Does that work? – Ben Thul Jul 21 '22 at 04:21
  • Thanks @BenThul, I will try. I don´t know much about Developer Edition, but I will try it. – Marcelo Sader Jul 29 '22 at 10:27

0 Answers0