How to create BAK file from azure sql db

sql-server azure azure-sql-server
Manu picture Manu · Apr 17, 2017 · Viewed 7.3k times · Source

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.

Answer

Amor picture Amor · Apr 17, 2017

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.

Related questions

How to set Azure SQL to rebuild indexes automatically?

In on premise SQL databases, it is normal to have a maintenance plan for rebuilding the indexes once in a while, when it is not being used that much. How can I set it up in Azure SQL DB? P.…

Read More
Use SQL Server Management Studio to connect remotely to an SQL Server Express instance hosted on an Azure Virtual Machine

Initial Attempt I have an Azure VM with Windows Server 2012, on which I just installed SQL Server 2012 Express Database Engine component. Then, I followed the instructions here to connect remotely with SQL Server Management Studio. Create a TCP endpoint for …

Read More
Optimal way to concatenate/aggregate strings

I'm finding a way to aggregate strings from different rows into a single row. I'm looking to do this in many different places, so having a function to facilitate this would be nice. I've tried solutions using COALESCE and FOR …

Read More