Export an Azure SQL Database
If you need to export your database
to another platform or archiving it, you can export the database schema and
data in a BACPAC file.
A BACPAC file is a ZIP file
with .bacpac extension
which contains the data from the SQL Server database.
It can be stored in either Azure
blob storage or in the on-premises location.
Later the file will be imported back
into Azure SQL database or into on-premises SQL server installation.
Considerations for Exporting your
Database
Some specific considerations while
exporting your database are:
1.
Ensure that no write activity is going on while
exporting.
2.
If you are exporting the BACPAC file to Azure blob
storage the upper limit of the file size is 200GB and the larger files are
recommended to store locally.
3.
Archiving to Azure premium storage by BACPAC file is
not supported.
4.
if the export operation from Azure SQL database exceeds
20hours, it refers to be canceled.
Comments
Post a Comment