Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create BAK file from azure sql db

I want to move my azure sql db to another host. However my new host allows to import sql db backup-files (.BAK) only; I found out how to generate .BACPAK files with SQL Server Management Studio but I could not find a way to create a BAK-file from my azure sql db. Please help.

like image 657
Manu Avatar asked Apr 17 '17 07:04

Manu


People also ask

How do I restore a BAK file from an Azure data studio?

Restore a database from a backup fileOpen the SERVERS sidebar by selecting Ctrl+G. Then right-click your server, and select Manage. Open the Restore database dialog box by selecting Restore on the Tasks widget. Select Backup file in the Restore from box.


1 Answers

However my new host allows to import sql db backup-files (.BAK) only;

SQL Azure doesn't provide a native way to generate '.bak' format backup file. If you did need this format file, you could import the BACPAC File to a local SQL Server which supports importing BACPAC File. After that, a new User Database will be created. Then you could generate a '.bak' format file from the local SQL Server.

In addition, you also could try a tool named SqlAzureBakMaker which could make '.bak' file for you easily.

like image 152
Amor Avatar answered Oct 14 '22 05:10

Amor