Export bacpac to a Azure storage account using powershell

Question

I'm trying to create a powershell script to backup a SQL database on Azure to a storage account as below,

$exportRequest = New-AzureRmSqlDatabaseExport -ResourceGroupName 
$ResourceGroupName -ServerName $ServerName `
-DatabaseName $DatabaseName -StorageKeytype $StorageKeytype -StorageKey 
$StorageKey -StorageUri $BacpacUri `
-AdministratorLogin $creds.UserName -AdministratorLoginPassword $creds.Password

This is the document i'm following,

https://learn.microsoft.com/en-us/azure/sql-database/sql-database-export

I assume the following,

$ResourceGroupName - my azure resource group
$ServerName - db server name
$DatabaseName - database name
**$StorageKeytype - NOT SURE WHAT VALUE SHOULD BE PLACED HERE**
**$StorageKey - I'm hoping this is one of the access keys under the azure storage account**
$BacpacUri - Azure storage account bacpac URI path

Please advice what parameters need to passed here.

Joy Wang · Accepted Answer · 2018-09-17 08:25:41Z

1

Please advice what parameters need to passed here.

StorageKey : Specifies the access key for the storage account.
StorageKeyType: Specifies the type of access key for the storage account.

The acceptable values for this parameter are:

StorageAccessKey. This value uses a storage account key.

SharedAccessKey. This value uses a Shared Access Signature (SAS) key.

For more details, refer to this link.

edited Sep 17, 2018 at 8:25

answered Sep 17, 2018 at 8:19

Joy Wang

42.4k3 gold badges38 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Aryan M Over a year ago

Thank you for replying Joy. Can you give me one example of what should be the value for the StorageKey Type. From my azure storage account, where should i be looking for this value?

Joy Wang Over a year ago

@AryanM Just use StorageAccessKey for the value of StorageKeyType.

Aryan M Over a year ago

I have updated my question with the snapshot of the AccessKey for my storage account on Azure. So, i suppose that will be my storageKey. If yes, what will be my storageKey Type?

Joy Wang Over a year ago

@AryanM The StorageKeyType just allows two values, in this case, specify the StorageKeyType with StorageAccessKey. Also, i recommend you to hide the sensitive information of your storage account in your question.

Aryan M Over a year ago

Thank you mate. Got it now.

|

Collectives™ on Stack Overflow

Export bacpac to a Azure storage account using powershell

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related