What format does the Shared Access Signature (SAS) key have in Powershell cmdlet New-AzureRmSqlDatabaseExport?

Question

I'm trying to export a Azure Sql database to a Azure storage with Powershell cmdlet New-AzureRmSqlDatabaseExport but can't seem to figure out how to use the -StorageKeyType = "SharedAccessKey" option where one is supposed enter Shared Access Signature (SAS) key for the -StorageKey parameter. It is not the SAS token, is it parts of this token or how does one find the correct key format?

Answer 1

Turns out it was the SaS token returned by New-AzureStorageContainerSASToken after all and format should include "?."

https://docs.microsoft.com/en-us/dotnet/api/microsoft.azure.management.sql.models.exportrequest?view=azure-dotnet

-StorageKeyType "SharedAccessKey" -StorageKey "?xxxxxxxxxxxxxxxx"

Answer 2

Below an example of how to use the StorageKeyType:

New-AzureRmSqlDatabaseExport -ServerName "xxxxx" -AuthenticationType Sql
-AdministratorLogin "xxx@xxxxx" -DatabaseName "xxxxx"
-StorageUri "xxxxxxx.blob.core.windows.net/xxxxx";
-StorageKey "xxxxxxxxxxxxxxxxxxxxxxxxxx/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx==" 
–ResourceGroupName "Default-SQL-SoutheastAsia" –StorageKeytype "StorageAccessKey" 

On the ServerName do not use the fully qualified name if you receive any errors.