你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

Databases - Create Import Operation

服务:: SQL Database

API 版本:: 2014-04-01

创建将 bacpac 导入现有数据库的导入作。现有数据库必须为空。

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

URI 参数

名称	在	必需	类型	说明
databaseName	path	True	string	要导入到的数据库的名称
extensionName	path	True	ExtensionName	要执行的作的名称
resourceGroupName	path	True	string	包含资源的资源组的名称。可以从 Azure 资源管理器 API 或门户获取此值。
serverName	path	True	string	服务器的名称。
subscriptionId	path	True	string	标识 Azure 订阅的订阅 ID。
api-version	query	True	string	要用于请求的 API 版本。

请求正文

名称	类型	说明
parameters	ImportExtensionRequest	将 Bacpac 导入数据库所需的参数。

响应

名称	类型	说明
201 Created	ImportExportResponse	还行
202 Accepted		已接受

示例

Import bacpac into an existing database Max with SAS key

Import bacpac into an existing database Max with storage key

Import bacpac into an existing database Min with SAS key

Import bacpac into an existing database Min with storage key

Import bacpac into an existing database Max with SAS key

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

{
  "name": "Import",
  "type": "Microsoft.Sql/servers/databases/extensions",
  "properties": {
    "operationMode": "Import",
    "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.ExtensionName;
import com.azure.resourcemanager.sql.models.ImportExtensionRequest;
import com.azure.resourcemanager.sql.models.ImportOperationMode;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases CreateImportOperation. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseUpdateImportMaxSasKey.json
     */
    /**
     * Sample code: Import bacpac into an existing database Max with SAS key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoAnExistingDatabaseMaxWithSASKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .createImportOperation(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                "testdb",
                ExtensionName.IMPORT,
                new ImportExtensionRequest()
                    .withName("Import")
                    .withType("Microsoft.Sql/servers/databases/extensions")
                    .withOperationMode(ImportOperationMode.IMPORT)
                    .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),
                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

示例响应

状态代码:: 201

{
  "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
  }
}

状态代码:: 202

Import bacpac into an existing database Max with storage key

示例请求

HTTP
Java

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

{
  "name": "Import",
  "type": "Microsoft.Sql/servers/databases/extensions",
  "properties": {
    "operationMode": "Import",
    "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.ExtensionName;
import com.azure.resourcemanager.sql.models.ImportExtensionRequest;
import com.azure.resourcemanager.sql.models.ImportOperationMode;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases CreateImportOperation. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseUpdateImportMaxStorageKey.json
     */
    /**
     * Sample code: Import bacpac into an existing database Max with storage key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoAnExistingDatabaseMaxWithStorageKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .createImportOperation(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                "testdb",
                ExtensionName.IMPORT,
                new ImportExtensionRequest()
                    .withName("Import")
                    .withType("Microsoft.Sql/servers/databases/extensions")
                    .withOperationMode(ImportOperationMode.IMPORT)
                    .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),
                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

示例响应

状态代码:: 201

{
  "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
  }
}

状态代码:: 202

Import bacpac into an existing database Min with SAS key

示例请求

HTTP
Java

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

{
  "properties": {
    "operationMode": "Import",
    "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.ExtensionName;
import com.azure.resourcemanager.sql.models.ImportExtensionRequest;
import com.azure.resourcemanager.sql.models.ImportOperationMode;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases CreateImportOperation. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseUpdateImportMinSasKey.json
     */
    /**
     * Sample code: Import bacpac into an existing database Min with SAS key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoAnExistingDatabaseMinWithSASKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .createImportOperation(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                "testdb",
                ExtensionName.IMPORT,
                new ImportExtensionRequest()
                    .withOperationMode(ImportOperationMode.IMPORT)
                    .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!"),
                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

示例响应

状态代码:: 201

{
  "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
  }
}

状态代码:: 202

Import bacpac into an existing database Min with storage key

示例请求

HTTP
Java

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

{
  "properties": {
    "operationMode": "Import",
    "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.ExtensionName;
import com.azure.resourcemanager.sql.models.ImportExtensionRequest;
import com.azure.resourcemanager.sql.models.ImportOperationMode;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases CreateImportOperation. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseUpdateImportMinStorageKey.json
     */
    /**
     * Sample code: Import bacpac into an existing database Min with storage key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void importBacpacIntoAnExistingDatabaseMinWithStorageKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .createImportOperation(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                "testdb",
                ExtensionName.IMPORT,
                new ImportExtensionRequest()
                    .withOperationMode(ImportOperationMode.IMPORT)
                    .withStorageKeyType(StorageKeyType.STORAGE_ACCESS_KEY)
                    .withStorageKey(
                        "sdlfkjdsf+sdlfkjsdlkfsjdfLDKFJSDLKFDFKLjsdfksjdflsdkfD2342309432849328479324/3RSD==")
                    .withStorageUri("https://test.blob.core.windows.net/bacpacs/testbacpac.bacpac")
                    .withAdministratorLogin("dummyLogin")
                    .withAdministratorLoginPassword("Un53cuRE!"),
                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

示例响应

状态代码:: 201

{
  "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
  }
}

状态代码:: 202

定义

名称	说明
AuthenticationType	身份验证类型。
ExtensionName	要执行的作的名称
ImportExportResponse	导入/导出获取作的响应。
ImportExtensionRequest	将 Bacpac 导入数据库所需的参数。
ImportOperationMode	正在执行的导入操作的类型。这始终是导入。
StorageKeyType	要使用的存储密钥的类型。

AuthenticationType

枚举

身份验证类型。

值	说明
SQL
ADPassword

ExtensionName

枚举

要执行的作的名称

值	说明
import

ImportExportResponse

Object

导入/导出获取作的响应。

名称	类型	说明
id	string	资源 ID。
name	string	资源名称。
properties.blobUri	string	Blob URI。
properties.databaseName	string	数据库的名称。
properties.errorMessage	string	从服务器返回的错误消息。
properties.lastModifiedTime	string	上次修改的作状态。
properties.queuedTime	string	作排队时间。
properties.requestId	string (uuid)	作的请求类型。
properties.requestType	string	作的请求类型。
properties.serverName	string	服务器的名称。
properties.status	string	从服务器返回的状态消息。
type	string	资源类型。

ImportExtensionRequest

Object

将 Bacpac 导入数据库所需的参数。

名称	类型	默认值	说明
name	string		扩展的名称。
properties.administratorLogin	string		SQL 管理员的名称。
properties.administratorLoginPassword	string		SQL 管理员的密码。
properties.authenticationType	AuthenticationType	SQL	身份验证类型。
properties.operationMode	ImportOperationMode		正在执行的导入操作的类型。这始终是导入。
properties.storageKey	string		要使用的存储密钥。如果存储密钥类型为 SharedAccessKey，则其前面必须有“？”。
properties.storageKeyType	StorageKeyType		要使用的存储密钥的类型。
properties.storageUri	string		要使用的存储 URI。
type	string		扩展的类型。

ImportOperationMode

枚举

正在执行的导入操作的类型。这始终是导入。

值	说明
Import

StorageKeyType

枚举

要使用的存储密钥的类型。

值	说明
StorageAccessKey
SharedAccessKey

通过

Databases - Create Import Operation

URI 参数

请求正文

响应

示例

Import bacpac into an existing database Max with SAS key

示例请求

示例响应

Import bacpac into an existing database Max with storage key

示例请求

示例响应

Import bacpac into an existing database Min with SAS key

示例请求

示例响应

Import bacpac into an existing database Min with storage key

示例请求

示例响应

定义

AuthenticationType

ExtensionName

ImportExportResponse

ImportExtensionRequest

ImportOperationMode

StorageKeyType