How can I move database from azure sql server to virtual machine?

Question

I'm having windows azure. I've two virtual machine setup in azure and both virtual machine has sites. I've database on azure sql server . I just want to move azure sql server database to virtual machine's sql server.

trailmax trailmax · Accepted Answer · 2014-07-03T22:21:00

You can also export you Azure SQL Database as BACPACK file, move it to your VM and import BACKPACK into on-prem database. This process is easier and has less than exporting via Data Export.

Here is an article how to export/import BACKPACK files: http://fabriccontroller.net/blog/posts/backup-and-restore-your-sql-azure-database-using-powershell/

Not much of GUI explained there, but the first 2 scereenshots show you how to get to exporting and importing menus.

I recommend to practice on non-production DBs first, before you go ahead with your critical data.

How can I move database from azure sql server to virtual machine?

2 Answers