| title | SqlPackage for Azure Synapse Analytics |
|---|---|
| description | Tips for using SqlPackage in Azure Synapse Analytics scenarios |
| ms.custom | tools|sos |
| ms.date | 03/10/2021 |
| ms.prod | sql |
| ms.reviewer | llali |
| ms.prod_service | sql-tools |
| ms.topic | conceptual |
| author | dzsquared |
| ms.author | drskwier |
This article highlights features of SqlPackage.exe that are focused on Azure Synapse Analytics databases.
To extract a schema to Azure Blob Storage, the following properties are required:
- /p:AzureStorageBlobEndpoint
- /p:AzureStorageContainer
- /p:AzureStorageKey
Access for extract is authorized via a storage account key. An additional parameter is optional, which sets the storage root path within the container:
- /p:AzureStorageRootPath
Without this property, the path defaults to servername/databasename/timestamp/.
To publish a schema from a dacpac in Azure Blob Storage, the following properties are required:
- /p:AzureStorageBlobEndpoint
- /p:AzureStorageContainer
- /p:AzureStorageRootPath
- /p:AzureStorageKey or /p:AzureSharedAccessSignatureToken
Access for publish can be authorized via a storage account key or a shared access signature (SAS) token.
- Learn more about Extract
- Learn more about Publish
- Learn more about Azure Blob Storage
- Learn more about Azure Storage Account Keys