Blog Post

Azure SQL Blog
6 MIN READ

Import Export using Private Link now in Preview

Sudhir_Raparla's avatar
Sudhir_Raparla
Icon for Microsoft rankMicrosoft
Mar 16, 2022
Import-Export overview With Azure SQL Import-Export users can import a SQL Server database into Azure SQL Database using a BACPAC file or export from an Azure SQL Database into a BACPAC file. BACPA...
Updated Oct 25, 2022
Version 2.0
azure sql database
zlovcevic's avatar
zlovcevic
Copper Contributor
Apr 06, 2022
DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
POST

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxxxxxxxx/resourceGroups/xxxxxxxxxx/providers/Microsoft.Sql/servers/xxxxxxxxxx/databases/xxxxxxxxxxx/export?api-version=2021-02-01-preview

Headers:
x-ms-client-request-id        : 8d7a39f8-1bd2-4a7d-9c9d-2d17577588a2
accept-language               : en-US

Body:
{
  "storageKeyType": "StorageAccessKey",
  "storageKey": "xxxxxxxxxxxxxxxxxxxxx",
  "storageUri": "https://xxxxxxxxxxxxxx.blob.core.windows.net/prod-general-storage/xxxxxxxxxxxxx-2022-04-06-10-12.bacpac",
  "administratorLogin": "xxxxxxxxxx",
  "administratorLoginPassword": "xxxxxxxxxxxxxxxxxx",
  "networkIsolation": {
    "storageAccountResourceId":
"/subscriptions/xxxxxxxxxxxxxxx/resourcegroups/xxxxxxxxxxxxxx/providers/Microsoft.Storage/storageAccounts/xxxxxxxxxxxxxx",
    "sqlServerResourceId":
"/subscriptions/xxxxxxxxxxxxxxx/resourceGroups/xxxxxxxxxxxxxxx/providers/Microsoft.Sql/servers/xxxxxxxxxxxxxx"
  }
}
DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
BadRequest

Headers:
Pragma                        : no-cache
x-ms-request-id               : db664f13-c094-443a-983a-15f5d7549ff8
x-ms-ratelimit-remaining-subscription-writes: 1199
x-ms-correlation-request-id   : 59c3c546-c567-4b16-a34a-f3866e816436
x-ms-routing-request-id       : NORTHEUROPE:20220406T082415Z:59c3c546-c567-4b16-a34a-f3866e816436
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
Cache-Control                 : no-cache
Date                          : Wed, 06 Apr 2022 08:24:15 GMT
Server                        : Microsoft-HTTPAPI/2.0

Body:
{
  "error": {
    "code": "InvalidImportExportParameter",
    "message": "The ImportExport input parameter
/subscriptions/xxxxxxxxxxxxxxxxx/resourcegroups/xxxxxxxxxxxxxxx/providers/Microsoft.Storage/storageAccounts/xxxxxxxxxxxxxx is
invalid. The Storage Account resource ID used for network isolation should be formatted like:
'/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Storage/storageAccounts/test-privatelink'."
  }
}