Creating a snapshoot from a serverless sql database on azure

Astrid Malanka 46 Reputation points
2022-08-19T17:35:43.553+00:00

Hello,

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?

Thanks

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 32,796 Reputation points MVP
    2022-08-19T17:53:14.417+00:00

    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 /SourceServerName:SampleSQLServer.sample.net,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
    2022-08-19T17:55:23.813+00:00

    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
    2022-08-19T20:11:31.36+00:00

    Thanks for your answer