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

Databases - Import

服务:

SQL Database

API 版本:

2014-04-01

将 bacpac 导入新数据库。

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

URI 参数

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

请求正文

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

响应

名称	类型	说明
200 OK	ImportExportResponse	确定
202 Accepted		已接受

示例

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

示例请求

HTTP

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

Java

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

示例响应

状态代码:

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

状态代码:

202

Import bacpac into new database Max with storage key

示例请求

HTTP

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

Java

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

示例响应

状态代码:

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

状态代码:

202

Import bacpac into new database Min with SAS key

示例请求

HTTP

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

Java

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

示例响应

状态代码:

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

状态代码:

202

Import bacpac into new database Min with storage key

示例请求

HTTP

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

Java

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

示例响应

状态代码:

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

状态代码:

202

定义

名称	说明
AuthenticationType	身份验证类型。
DatabaseEdition	正在创建的数据库的版本。 SKU 列表可能因地区和支持产品/服务而异。 若要确定 SKU (包括 AZURE 区域中订阅可用的 SKU 名称、层/版本、系列和容量) ，请使用 Capabilities_ListByLocation REST API 或以下命令之一： az sql db list-editions -l <location> -o table Get-AzSqlServerServiceObjective -Location <location>
ImportExportResponse	对导入/导出 Get 操作的响应。
ImportRequest	将 Bacpac 导入数据库所需的参数。
ServiceObjectiveName	要分配给数据库的服务目标的名称。
StorageKeyType	要使用的存储密钥的类型。

AuthenticationType

身份验证类型。

名称	类型	说明
ADPassword	string
SQL	string

DatabaseEdition

正在创建的数据库的版本。

SKU 列表可能因地区和支持产品/服务而异。 若要确定 SKU (包括 AZURE 区域中订阅可用的 SKU 名称、层/版本、系列和容量) ，请使用 Capabilities_ListByLocation REST API 或以下命令之一：

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

Get-AzSqlServerServiceObjective -Location <location>

名称	类型	说明
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

对导入/导出 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	资源类型。

ImportRequest

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

名称	类型	默认值	说明
administratorLogin	string		SQL 管理员的名称。
administratorLoginPassword	string		SQL 管理员的密码。
authenticationType	AuthenticationType	SQL	身份验证类型。
databaseName	string		要导入的数据库的名称。
edition	DatabaseEdition		正在创建的数据库的版本。 SKU 列表可能因地区和支持产品/服务而异。 若要确定 SKU (包括 AZURE 区域中订阅可用的 SKU 名称、层/版本、系列和容量) ，请使用 Capabilities_ListByLocation REST API 或以下命令之一： az sql db list-editions -l <location> -o table Get-AzSqlServerServiceObjective -Location <location>
maxSizeBytes	string		新导入的数据库的最大大小。
serviceObjectiveName	ServiceObjectiveName		要分配给数据库的服务目标的名称。
storageKey	string		要使用的存储密钥。 如果存储密钥类型为 SharedAccessKey，则必须以“?”为前缀。
storageKeyType	StorageKeyType		要使用的存储密钥的类型。
storageUri	string		要使用的存储 URI。

ServiceObjectiveName

要分配给数据库的服务目标的名称。

名称	类型	说明
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

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

名称	类型	说明
SharedAccessKey	string
StorageAccessKey	string