converting SQL . BAK to SQL backpac format

Question

I have MSSQL .BAK file, and for logistical reason (the DB being huge for my infra) I want to convert the same to BacPac file, so that I could upload the same to Azure.

All this while I thought .BAK and BacPac are same, so there was error, is there a utility to get it converted?

Jellify

Answer 1

They are different formats. "bacpac" files do not include Transaction logs and are not transitionally consistent by themselves. You can read more about it here "Windows Azure SQL Database Backup and Restore Strategy"

Your best path would be to restore the backup (".bak") of the database to a local server, and then to create a ".bacpac" file from the restored DB. You don't need the restored local copy of the DB to be high performance (other than for the purposes of extracting its data into the bacpac) so you can restore it onto a server that just has enough space to accommodate the data. That should help with the "the DB being huge for my infra" problem.

Nail

Is there any chance this answer is old and new tooling exists? I have a need to import a .bak from a third party and restore to azure Sql on a periodic interval. Really don want it to become a manual process that involves anything local. – Spout

@Spout I found this that could get you started on building tooling devblogs.microsoft.com/azure-sql/… – Rheinlander

Answer 2

I used the Microsoft SQL Server management studio and it work well: converting .sql to .bacpac/ bak

Saraband

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center. – Placate