Clever Geek Handbook

How to create BAK file from azure sql db

I want to migrate my azure sql-db to another host. However, my new host only allows me to import sql db (.BAK) backup files; I found out how to generate .BACPAK files using SQL Server Management Studio, but I couldn't find a way to generate a BAK file from my lzz sql db. Please, help.

+3


source to share


1 answer


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

SQL Azure does not provide its own way to create a .bak backup file. If you need this format file, you can import the BACPAC file to your local SQL Server, which supports importing the BACPAC file. This will create a new user database. Then you can generate a ".bak" file from your local SQL Server.



Alternatively, you can also try a tool called SqlAzureBakMaker , which could easily make a ".bak" file.

+3


source






More articles:


All Articles