你当前正在访问 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	对导入/导出 Get 操作的响应。
ImportExtensionRequest	将 Bacpac 导入数据库所需的参数。
ImportOperationMode	正在执行的导入操作的类型。这始终为 Import。
StorageKeyType	要使用的存储密钥的类型。

AuthenticationType

身份验证类型。

名称	类型	说明
ADPassword	string
SQL	string

ExtensionName

要执行的操作的名称

名称	类型	说明
import	string

ImportExportResponse

对导入/导出 Get 操作的响应。

名称	类型	说明
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	操作的请求类型。
properties.requestType	string	操作的请求类型。
properties.serverName	string	服务器的名称。
properties.status	string	从服务器返回的状态消息。
type	string	资源类型。

ImportExtensionRequest

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

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

ImportOperationMode

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

名称	类型	说明
Import	string

StorageKeyType

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

名称	类型	说明
SharedAccessKey	string
StorageAccessKey	string

通过

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

其他资源