Databases - Export

Referens

Tjänst:: SQL Database

API-version:: 2014-04-01

Exporterar en databas till en bacpac.

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

URI-parametrar

Name	I	Obligatorisk	Typ	Description
databaseName	path	True	string	Namnet på databasen som ska exporteras.
resourceGroupName	path	True	string	Namnet på resursgruppen som innehåller resursen. Du kan hämta det här värdet från Azure Resource Manager-API:et eller portalen.
serverName	path	True	string	Namnet på servern.
subscriptionId	path	True	string	Prenumerations-ID:t som identifierar en Azure-prenumeration.
api-version	query	True	string	DEN API-version som ska användas för begäran.

Begärandetext

Name	Typ	Description
parameters	ExportRequest	De parametrar som krävs för att exportera en databas.

Svar

Name	Typ	Description
200 OK	ImportExportResponse	OK
202 Accepted		Har godkänts

Exempel

Export a database into a new bacpac file with SAS key

Export a database into a new bacpac file with storage key

Export a database into a new bacpac file with SAS key

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

{
  "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.ExportRequest;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases Export. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseExportSasKey.json
     */
    /**
     * Sample code: Export a database into a new bacpac file with SAS key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void exportADatabaseIntoANewBacpacFileWithSASKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .export(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                "testdb",
                new ExportRequest()
                    .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

Exempelsvar

Statuskod:: 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": "Export",
    "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
  }
}

Statuskod:: 202

Export a database into a new bacpac file with storage key

Exempelbegäran

HTTP
Java

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

{
  "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.ExportRequest;
import com.azure.resourcemanager.sql.models.StorageKeyType;

/** Samples for Databases Export. */
public final class Main {
    /*
     * x-ms-original-file: specification/sql/resource-manager/Microsoft.Sql/stable/2014-04-01/examples/DatabaseExportStorageKey.json
     */
    /**
     * Sample code: Export a database into a new bacpac file with storage key.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void exportADatabaseIntoANewBacpacFileWithStorageKey(
        com.azure.resourcemanager.AzureResourceManager azure) {
        azure
            .sqlServers()
            .manager()
            .serviceClient()
            .getDatabases()
            .export(
                "sqlcrudtest-4799",
                "sqlcrudtest-5961",
                "testdb",
                new ExportRequest()
                    .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

Exempelsvar

Statuskod:: 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": "Export",
    "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
  }
}

Statuskod:: 202

Definitioner

Name	Description
AuthenticationType	Autentiseringstypen.
ExportRequest	De parametrar som krävs för att exportera en databas.
ImportExportResponse	Svar för import-/exportåtgärden Hämta.
StorageKeyType	Typ av lagringsnyckel som ska användas.

AuthenticationType

Autentiseringstypen.

Name	Typ	Description
ADPassword	string
SQL	string

ExportRequest

De parametrar som krävs för att exportera en databas.

Name	Typ	Standardvärde	Description
administratorLogin	string		Namnet på SQL-administratören.
administratorLoginPassword	string		Lösenordet för SQL-administratören.
authenticationType	AuthenticationType	SQL	Autentiseringstypen.
storageKey	string		Lagringsnyckeln som ska användas. Om lagringsnyckeltypen är SharedAccessKey måste den föregås av ett ”?”.
storageKeyType	StorageKeyType		Typ av lagringsnyckel som ska användas.
storageUri	string		Lagrings-URI:n som ska användas.

ImportExportResponse

Svar för import-/exportåtgärden Hämta.

Name	Typ	Description
id	string	Resurs-ID.
name	string	Resursnamn.
properties.blobUri	string	Blob-URI:n.
properties.databaseName	string	Namnet på databasen.
properties.errorMessage	string	Felmeddelandet som returnerades från servern.
properties.lastModifiedTime	string	Åtgärdsstatusen ändrades senast.
properties.queuedTime	string	Åtgärden köade tid.
properties.requestId	string	Åtgärdens typ av begäran.
properties.requestType	string	Åtgärdens typ av begäran.
properties.serverName	string	Namnet på servern.
properties.status	string	Statusmeddelandet som returnerades från servern.
type	string	Resurstyp.

StorageKeyType

Typ av lagringsnyckel som ska användas.

Name	Typ	Description
SharedAccessKey	string
StorageAccessKey	string

Dela via

Databases - Export

URI-parametrar

Begärandetext

Svar

Exempel

Export a database into a new bacpac file with SAS key

Exempelbegäran

Exempelsvar

Export a database into a new bacpac file with storage key

Exempelbegäran

Exempelsvar

Definitioner

AuthenticationType

ExportRequest

ImportExportResponse

StorageKeyType

Ytterligare resurser