Blog Post

Azure Database Support Blog
3 MIN READ

Using SQLPackage to import or export SQL Server and Azure SQL DB

Yochanan_Rachamim's avatar
Yochanan_Rachamim
Icon for Microsoft rankMicrosoft
Mar 14, 2019
First published on MSDN on Jan 31, 2017, Updated Feb 7th, 2023 Purpose: Explain how to easily and quickly use SQLPackage to import or export your SQL Server and Azure SQL Database.   Locatin...
Updated Feb 07, 2023
Version 5.0
bia_e's avatar
bia_e
Copper Contributor
Mar 14, 2022

Unfortunately I didn't find anything that clearly explains what these properties should do either:

 

/p: AzureStorageBlobEndpoint=(STRING)= Azure blob storage endpoint, see SqlPackage for Azure Synapse Analytics.
/p: AzureStorageContainer=(STRING) =Azure blob storage container, see SqlPackage for Azure Synapse Analytics.
/p: AzureStorageKey=(STRING) =Azure storage account key, see SqlPackage for Azure Synapse Analytics.
/p: AzureStorageRootPath=(STRING)= Storage root path within the container. Without this property, the path defaults to servername/databasename/timestamp/. See SqlPackage for Azure Synapse Analytics.


https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-extract?view=sql-server-ver15

 

Even after filling them in, it didn't result in the process I expected, it wasn't written to storage. I found this property confusing but I didn't find any example of use either...

 

I'll try to find another way.

Anyway thank you so much for the support astanton1978