Search Results for

    Show / Hide Table of Contents

    Convert .bacpac to .bak

    If you have a .bacpac file, e.g. from an Azure SQL database and want to convert it to a .bak file, you can use this functionality. It will start a SQL Server container, restore the .bacpac file to a database and then create a .bak file from it. Currently the only supported way to get a .bacpac file into the service is to store in the Azure File Share connected to your backend.

    • GitHub (AL-Go)
    • Azure DevOps

    WIP

    To convert a .bacpac file, take these steps:

    1. Upload the file to the Azure File Share directly in the root folder or in a subfolder. For this example, let's assume that you put it in a folder called "backups" and the name of the file is "database-backup.bacpac"
    2. Go to an organization, project and repository of your chosing. The conversion is not actually connected to the repository, but the container will appear below that repository.
    3. Do a right-click on the containers item and select "convert bacpac to bak"
    4. Enter the path to your .bacpac file and hit enter
    5. Optionally enter a company name if you want to remove all companies except that one during the conversion
    6. You will see a message that it might take a while to start, which is the case if the container image was never used on your backend
    7. After it was pulled or immediately if it was already available, you will see a message that the container was created
    8. In the container list, you will now see one called "Backup Converter". Do a right click on it and select "Open log"
    9. You can ignore the first couple of lines until you see "SQL Server ready"
    10. Wait until you can see in the log that the SQL server is stopped again. Note that the conversion will take a couple of minutes even for smaller databases and can take hours for medium or large databases
    11. You will find a file with the same filename, but extension .bak in the same folder as the original .bacpac file
    12. Delete the container

    You can see a walkthrough here:

    Your browser does not support the video tag.
    In This Article
    Back to top 2025 © COSMO CONSULT - Data protection - Imprint