Databases - Import

Reference

Service:: SQL Database

API Version:: 2014-04-01

Imports a bacpac into a new database.

POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/import?api-version=2014-04-01

URI Parameters

Name	In	Required	Type	Description
resourceGroupName	path	True	string	The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
serverName	path	True	string	The name of the server.
subscriptionId	path	True	string	The subscription ID that identifies an Azure subscription.
api-version	query	True	string	The API version to use for the request.

Request Body

Name	Type	Description
parameters	ImportRequest	The required parameters for importing a Bacpac into a database.

Responses

Name	Type	Description
200 OK	ImportExportResponse	OK
202 Accepted		Accepted

Examples

Import bacpac into new database Max with SAS key

Import bacpac into new database Max with storage key

Import bacpac into new database Min with SAS key

Import bacpac into new database Min with storage key

Import bacpac into new database Max with SAS key

POST https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/import?api-version=2014-04-01

{
  "databaseName": "TestDbImport",
  "edition": "Basic",
  "serviceObjectiveName": "Basic",
  "maxSizeBytes": "2147483648",
  "storageKeyType": "SharedAccessKey",
  "storageKey": "?sr=b&sp=rw&se=2018-01-01T00%3A00%3A00Z&sig=sdfsdfklsdjflSLIFJLSIEJFLKSDJFDd/%2wdfskdjf3%3D&sv=2015-07-08",
  "storageUri": "https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac",
  "administratorLogin": "dummyLogin",
  "administratorLoginPassword": "<administratorLoginPassword>",
  "authenticationType": "SQL"
}

import com.azure.core.util.Context;
import com.azure.resourcemanager.sql.models.AuthenticationType;
import com.azure.resourcemanager.sql.models.DatabaseEdition;
import com.azure.resourcemanager.sql.models.ImportRequest;
import com.azure.resourcemanager.sql.models.ServiceObjectiveName;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases ImportMethod. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseCreateImportMaxSasKey.json
     */
    /**
     * Sample code: Import bacpac into new database Max with SAS key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoNewDatabaseMaxWithSASKey(com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .importMethod(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                new ImportRequest()
                    .withStorageKeyType(StorageKeyType.SHARED_ACCESS_KEY)
                    .withStorageKey(
                        "?sr=b&sp=rw&se=2018-01-01T00%3A00%3A00Z&sig=sdfsdfklsdjflSLIFJLSIEJFLKSDJFDd/%2wdfskdjf3%3D&sv=2015-07-08")
                    .withStorageUri("https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac")
                    .withAdministratorLogin("dummyLogin")
                    .withAdministratorLoginPassword("Un53cuRE!")
                    .withAuthenticationType(AuthenticationType.SQL)
                    .withDatabaseName("TestDbImport")
                    .withEdition(DatabaseEdition.BASIC)
                    .withServiceObjectiveName(ServiceObjectiveName.BASIC)
                    .withMaxSizeBytes("2147483648"),
                Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/importExportOperationResult/f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "name": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "type": "Microsoft.Sql/servers/importExportOperationResults",
  "properties": {
    "requestId": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
    "requestType": "Import",
    "queuedTime": "3/1/2017 12:14:25 AM",
    "lastModifiedTime": "3/1/2017 12:16:33 AM",
    "blobUri": "https://test.blob.core.windows.net/bacpacs/test.bacpac",
    "serverName": "test",
    "databaseName": "testdb",
    "status": "Completed",
    "errorMessage": null
  }
}

Status code:: 202

Import bacpac into new database Max with storage key

Sample request

HTTP
Java

POST https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/import?api-version=2014-04-01

{
  "databaseName": "TestDbImport",
  "edition": "Basic",
  "serviceObjectiveName": "Basic",
  "maxSizeBytes": "2147483648",
  "storageKeyType": "StorageAccessKey",
  "storageKey": "sdlfkjdsf+sdlfkjsdlkfsjdfLDKFJSDLKFDFKLjsdfksjdflsdkfD2342309432849328479324/3RSD==",
  "storageUri": "https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac",
  "administratorLogin": "dummyLogin",
  "administratorLoginPassword": "<administratorLoginPassword>",
  "authenticationType": "SQL"
}

import com.azure.core.util.Context;
import com.azure.resourcemanager.sql.models.AuthenticationType;
import com.azure.resourcemanager.sql.models.DatabaseEdition;
import com.azure.resourcemanager.sql.models.ImportRequest;
import com.azure.resourcemanager.sql.models.ServiceObjectiveName;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases ImportMethod. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseCreateImportMaxStorageKey.json
     */
    /**
     * Sample code: Import bacpac into new database Max with storage key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoNewDatabaseMaxWithStorageKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .importMethod(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                new ImportRequest()
                    .withStorageKeyType(StorageKeyType.STORAGE_ACCESS_KEY)
                    .withStorageKey(
                        "sdlfkjdsf+sdlfkjsdlkfsjdfLDKFJSDLKFDFKLjsdfksjdflsdkfD2342309432849328479324/3RSD==")
                    .withStorageUri("https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac")
                    .withAdministratorLogin("dummyLogin")
                    .withAdministratorLoginPassword("Un53cuRE!")
                    .withAuthenticationType(AuthenticationType.SQL)
                    .withDatabaseName("TestDbImport")
                    .withEdition(DatabaseEdition.BASIC)
                    .withServiceObjectiveName(ServiceObjectiveName.BASIC)
                    .withMaxSizeBytes("2147483648"),
                Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/importExportOperationResult/f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "name": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "type": "Microsoft.Sql/servers/importExportOperationResults",
  "properties": {
    "requestId": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
    "requestType": "Import",
    "queuedTime": "3/1/2017 12:14:25 AM",
    "lastModifiedTime": "3/1/2017 12:16:33 AM",
    "blobUri": "https://test.blob.core.windows.net/bacpacs/test.bacpac",
    "serverName": "test",
    "databaseName": "testdb",
    "status": "Completed",
    "errorMessage": null
  }
}

Status code:: 202

Import bacpac into new database Min with SAS key

Sample request

HTTP
Java

POST https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/import?api-version=2014-04-01

{
  "databaseName": "TestDbImport",
  "edition": "Basic",
  "serviceObjectiveName": "Basic",
  "maxSizeBytes": "2147483648",
  "storageKeyType": "SharedAccessKey",
  "storageKey": "?sr=b&sp=rw&se=2018-01-01T00%3A00%3A00Z&sig=sdfsdfklsdjflSLIFJLSIEJFLKSDJFDd/%2wdfskdjf3%3D&sv=2015-07-08",
  "storageUri": "https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac",
  "administratorLogin": "dummyLogin",
  "administratorLoginPassword": "<administratorLoginPassword>"
}

import com.azure.core.util.Context;
import com.azure.resourcemanager.sql.models.DatabaseEdition;
import com.azure.resourcemanager.sql.models.ImportRequest;
import com.azure.resourcemanager.sql.models.ServiceObjectiveName;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases ImportMethod. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseCreateImportMinSasKey.json
     */
    /**
     * Sample code: Import bacpac into new database Min with SAS key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoNewDatabaseMinWithSASKey(com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .importMethod(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                new ImportRequest()
                    .withStorageKeyType(StorageKeyType.SHARED_ACCESS_KEY)
                    .withStorageKey(
                        "?sr=b&sp=rw&se=2018-01-01T00%3A00%3A00Z&sig=sdfsdfklsdjflSLIFJLSIEJFLKSDJFDd/%2wdfskdjf3%3D&sv=2015-07-08")
                    .withStorageUri("https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac")
                    .withAdministratorLogin("dummyLogin")
                    .withAdministratorLoginPassword("Un53cuRE!")
                    .withDatabaseName("TestDbImport")
                    .withEdition(DatabaseEdition.BASIC)
                    .withServiceObjectiveName(ServiceObjectiveName.BASIC)
                    .withMaxSizeBytes("2147483648"),
                Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/importExportOperationResult/f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "name": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "type": "Microsoft.Sql/servers/importExportOperationResults",
  "properties": {
    "requestId": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
    "requestType": "Import",
    "queuedTime": "3/1/2017 12:14:25 AM",
    "lastModifiedTime": "3/1/2017 12:16:33 AM",
    "blobUri": "https://test.blob.core.windows.net/bacpacs/test.bacpac",
    "serverName": "test",
    "databaseName": "testdb",
    "status": "Completed",
    "errorMessage": null
  }
}

Status code:: 202

Import bacpac into new database Min with storage key

Sample request

HTTP
Java

POST https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/import?api-version=2014-04-01

{
  "databaseName": "TestDbImport",
  "edition": "Basic",
  "serviceObjectiveName": "Basic",
  "maxSizeBytes": "2147483648",
  "storageKeyType": "StorageAccessKey",
  "storageKey": "sdlfkjdsf+sdlfkjsdlkfsjdfLDKFJSDLKFDFKLjsdfksjdflsdkfD2342309432849328479324/3RSD==",
  "storageUri": "https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac",
  "administratorLogin": "dummyLogin",
  "administratorLoginPassword": "<administratorLoginPassword>"
}

import com.azure.core.util.Context;
import com.azure.resourcemanager.sql.models.DatabaseEdition;
import com.azure.resourcemanager.sql.models.ImportRequest;
import com.azure.resourcemanager.sql.models.ServiceObjectiveName;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases ImportMethod. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseCreateImportMinStorageKey.json
     */
    /**
     * Sample code: Import bacpac into new database Min with storage key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoNewDatabaseMinWithStorageKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .importMethod(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                new ImportRequest()
                    .withStorageKeyType(StorageKeyType.STORAGE_ACCESS_KEY)
                    .withStorageKey(
                        "sdlfkjdsf+sdlfkjsdlkfsjdfLDKFJSDLKFDFKLjsdfksjdflsdkfD2342309432849328479324/3RSD==")
                    .withStorageUri("https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac")
                    .withAdministratorLogin("dummyLogin")
                    .withAdministratorLoginPassword("Un53cuRE!")
                    .withDatabaseName("TestDbImport")
                    .withEdition(DatabaseEdition.BASIC)
                    .withServiceObjectiveName(ServiceObjectiveName.BASIC)
                    .withMaxSizeBytes("2147483648"),
                Context.NONE);
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Sample response

Status code:: 200

{
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-4799/providers/Microsoft.Sql/servers/sqlcrudtest-5961/importExportOperationResult/f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "name": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
  "type": "Microsoft.Sql/servers/importExportOperationResults",
  "properties": {
    "requestId": "f01d7bfe-7162-44e7-9350-f1c85ce83e4c",
    "requestType": "Import",
    "queuedTime": "3/1/2017 12:14:25 AM",
    "lastModifiedTime": "3/1/2017 12:16:33 AM",
    "blobUri": "https://test.blob.core.windows.net/bacpacs/test.bacpac",
    "serverName": "test",
    "databaseName": "testdb",
    "status": "Completed",
    "errorMessage": null
  }
}

Status code:: 202

Definitions

Name	Description
AuthenticationType	The authentication type.
DatabaseEdition	The edition for the database being created. The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the `Capabilities_ListByLocation` REST API or one of the following commands: `az sql db list-editions -l <location> -o table` `Get-AzSqlServerServiceObjective -Location <location>`
ImportExportResponse	Response for Import/Export Get operation.
ImportRequest	The required parameters for importing a Bacpac into a database.
ServiceObjectiveName	The name of the service objective to assign to the database.
StorageKeyType	The type of the storage key to use.

AuthenticationType

The authentication type.

Name	Type	Description
ADPassword	string
SQL	string

DatabaseEdition

The edition for the database being created.

The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the Capabilities_ListByLocation REST API or one of the following commands:

az sql db list-editions -l <location> -o table

Get-AzSqlServerServiceObjective -Location <location>

Name	Type	Description
Basic	string
Business	string
BusinessCritical	string
DataWarehouse	string
Free	string
GeneralPurpose	string
Hyperscale	string
Premium	string
PremiumRS	string
Standard	string
Stretch	string
System	string
System2	string
Web	string

ImportExportResponse

Response for Import/Export Get operation.

Name	Type	Description
id	string	Resource ID.
name	string	Resource name.
properties.blobUri	string	The blob uri.
properties.databaseName	string	The name of the database.
properties.errorMessage	string	The error message returned from the server.
properties.lastModifiedTime	string	The operation status last modified time.
properties.queuedTime	string	The operation queued time.
properties.requestId	string	The request type of the operation.
properties.requestType	string	The request type of the operation.
properties.serverName	string	The name of the server.
properties.status	string	The status message returned from the server.
type	string	Resource type.

ImportRequest

The required parameters for importing a Bacpac into a database.

Name	Type	Default value	Description
administratorLogin	string		The name of the SQL administrator.
administratorLoginPassword	string		The password of the SQL administrator.
authenticationType	AuthenticationType	SQL	The authentication type.
databaseName	string		The name of the database to import.
edition	DatabaseEdition		The edition for the database being created. The list of SKUs may vary by region and support offer. To determine the SKUs (including the SKU name, tier/edition, family, and capacity) that are available to your subscription in an Azure region, use the `Capabilities_ListByLocation` REST API or one of the following commands: `az sql db list-editions -l <location> -o table` `Get-AzSqlServerServiceObjective -Location <location>`
maxSizeBytes	string		The maximum size for the newly imported database.
serviceObjectiveName	ServiceObjectiveName		The name of the service objective to assign to the database.
storageKey	string		The storage key to use. If storage key type is SharedAccessKey, it must be preceded with a "?."
storageKeyType	StorageKeyType		The type of the storage key to use.
storageUri	string		The storage uri to use.

ServiceObjectiveName

The name of the service objective to assign to the database.

Name	Type	Description
Basic	string
DS100	string
DS1000	string
DS1200	string
DS1500	string
DS200	string
DS2000	string
DS300	string
DS400	string
DS500	string
DS600	string
DW100	string
DW1000	string
DW10000c	string
DW1000c	string
DW1200	string
DW1500	string
DW15000c	string
DW1500c	string
DW200	string
DW2000	string
DW2000c	string
DW2500c	string
DW300	string
DW3000	string
DW30000c	string
DW3000c	string
DW400	string
DW500	string
DW5000c	string
DW600	string
DW6000	string
DW6000c	string
DW7500c	string
ElasticPool	string
Free	string
P1	string
P11	string
P15	string
P2	string
P3	string
P4	string
P6	string
PRS1	string
PRS2	string
PRS4	string
PRS6	string
S0	string
S1	string
S12	string
S2	string
S3	string
S4	string
S6	string
S7	string
S9	string
System	string
System0	string
System1	string
System2	string
System2L	string
System3	string
System3L	string
System4	string
System4L	string

StorageKeyType

The type of the storage key to use.

Name	Type	Description
SharedAccessKey	string
StorageAccessKey	string

Share via

Databases - Import

URI Parameters

Request Body

Responses

Examples

Import bacpac into new database Max with SAS key

Sample request

Sample response

Import bacpac into new database Max with storage key

Sample request

Sample response

Import bacpac into new database Min with SAS key

Sample request

Sample response

Import bacpac into new database Min with storage key

Sample request

Sample response

Definitions

AuthenticationType

DatabaseEdition

ImportExportResponse

ImportRequest

ServiceObjectiveName

StorageKeyType

Additional resources