Creating a snapshoot from a serverless sql database on azure

Question

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

Answer 1

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"  

Answer 2

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.

Answer 3

Thanks for your answer