Creating a snapshoot from a serverless sql database on azure

Astrid Malanka 46 Reputation points


I have a serverless sql database in azure and I would like to create a daily snapshot that I can load to my on prem db so the analysts can query around.
I cannot find any documentation on how to do it, can someone please point me to the correct direction?


Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,796 Reputation points MVP

    You can export your Azure database as a bacpac and save it to a local drive on on-premise computer, and then you can import the bacpac to an on-premise SQL Server 2019 instance with all cumulative updates applied. You can use SQL Server Management Studio v19 (Preview 3) to do the import and avoid issues importing the bacpac to the SQL Server instance.

    You can use sqlpakage utilty to export the database to a local drive:

    SqlPackage /Action:Export /,1433 /SourceDatabaseName:SampleDatabase /TargetFile:"F:\Temp\SampleDatabase.bacpac"  
    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Astrid Malanka 46 Reputation points

    Thanks, but can I do it as a job or a chore or something? I need to run the export every day, or better said I need a fresh copy.

  2. Astrid Malanka 46 Reputation points

    Thanks for your answer