openapi: 3.2.0
info:
  title: Microsoft Azure Azure SQL Database Import/Export spec…
  description: Provides create and read functionality for Import/Export operations on Azure SQL databases.
  version: '2014-04-01'
servers:
- url: https://management.azure.com
tags:
- name: Import Export
paths:
  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/import:
    post:
      tags:
      - Import Export
      operationId: microsoftAzureDatabasesImport
      description: Imports a bacpac into a new database.
      parameters:
      - $ref: ../../../common/v1/types.json#/parameters/ApiVersionParameter
      - $ref: ../../../common/v1/types.json#/parameters/SubscriptionIdParameter
      - $ref: ../../../common/v1/types.json#/parameters/ResourceGroupParameter
      - $ref: '#/components/parameters/ServerNameParameter'
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ImportExportResponse'
        '202':
          description: Accepted
      x-ms-examples:
        Import bacpac into new database Max with storage key:
          $ref: ./examples/DatabaseCreateImportMaxStorageKey.json
        Import bacpac into new database Min with storage key:
          $ref: ./examples/DatabaseCreateImportMinStorageKey.json
        Import bacpac into new database Max with SAS key:
          $ref: ./examples/DatabaseCreateImportMaxSasKey.json
        Import bacpac into new database Min with SAS key:
          $ref: ./examples/DatabaseCreateImportMinSasKey.json
      x-ms-long-running-operation: true
      summary: Microsoft Azure Post Subscriptions Subscriptionid Resourcegroups…
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ImportRequest'
        description: The required parameters for importing a Bacpac into a database.
        required: true
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/extensions/{extensionName}
  : put:
      tags:
      - Import Export
      operationId: microsoftAzureDatabasesCreateimportoperation
      description: Creates an import operation that imports a bacpac into an existing database. The existing database must be empty.
      parameters:
      - $ref: ../../../common/v1/types.json#/parameters/ApiVersionParameter
      - $ref: ../../../common/v1/types.json#/parameters/SubscriptionIdParameter
      - $ref: ../../../common/v1/types.json#/parameters/ResourceGroupParameter
      - $ref: '#/components/parameters/ServerNameParameter'
      - name: databaseName
        in: path
        required: true
        description: The name of the database to import into
        schema:
          type: string
      - name: extensionName
        in: path
        required: true
        description: The name of the operation to perform
        x-ms-enum:
          name: ExtensionName
          modelAsString: true
        schema:
          type: string
          enum:
          - import
      responses:
        '201':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ImportExportResponse'
        '202':
          description: Accepted
      x-ms-examples:
        Import bacpac into an existing database Max with storage key:
          $ref: ./examples/DatabaseUpdateImportMaxStorageKey.json
        Import bacpac into an existing database Min with storage key:
          $ref: ./examples/DatabaseUpdateImportMinStorageKey.json
        Import bacpac into an existing database Max with SAS key:
          $ref: ./examples/DatabaseUpdateImportMaxSasKey.json
        Import bacpac into an existing database Min with SAS key:
          $ref: ./examples/DatabaseUpdateImportMinSasKey.json
      x-ms-long-running-operation: true
      summary: Microsoft Azure Put Subscriptions Subscriptionid Resourcegroups…
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ImportExtensionRequest'
        description: The required parameters for importing a Bacpac into a database.
        required: true
  ? /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/export
  : post:
      tags:
      - Import Export
      operationId: microsoftAzureDatabasesExport
      description: Exports a database to a bacpac.
      parameters:
      - $ref: ../../../common/v1/types.json#/parameters/ApiVersionParameter
      - $ref: ../../../common/v1/types.json#/parameters/SubscriptionIdParameter
      - $ref: ../../../common/v1/types.json#/parameters/ResourceGroupParameter
      - $ref: '#/components/parameters/ServerNameParameter'
      - name: databaseName
        in: path
        required: true
        description: The name of the database to be exported.
        schema:
          type: string
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/ImportExportResponse'
        '202':
          description: Accepted
      x-ms-examples:
        Export a database into a new bacpac file with storage key:
          $ref: ./examples/DatabaseExportStorageKey.json
        Export a database into a new bacpac file with SAS key:
          $ref: ./examples/DatabaseExportSasKey.json
      x-ms-long-running-operation: true
      summary: Microsoft Azure Post Subscriptions Subscriptionid Resourcegroups…
      requestBody:
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/ExportRequest'
        description: The required parameters for exporting a database.
        required: true
components:
  schemas:
    ExportRequest:
      properties:
        storageKeyType:
          type: string
          description: The type of the storage key to use.
          enum:
          - StorageAccessKey
          - SharedAccessKey
          x-ms-enum:
            name: StorageKeyType
        storageKey:
          type: string
          description: The storage key to use.  If storage key type is SharedAccessKey, it must be preceded with a "?."
        storageUri:
          type: string
          description: The storage uri to use.
        administratorLogin:
          type: string
          description: The name of the SQL administrator.
        administratorLoginPassword:
          type: string
          description: The password of the SQL administrator.
        authenticationType:
          type: string
          description: The authentication type.
          enum:
          - SQL
          - ADPassword
          x-ms-enum:
            name: AuthenticationType
          default: SQL
      required:
      - storageKeyType
      - storageKey
      - storageUri
      - administratorLogin
      - administratorLoginPassword
      description: Export database parameters.
    ImportExtensionProperties:
      properties:
        operationMode:
          type: string
          description: The type of import operation being performed. This is always Import.
          enum:
          - Import
          x-ms-enum:
            name: ImportOperationMode
      required:
      - operationMode
      allOf:
      - $ref: '#/components/schemas/ExportRequest'
      description: Represents the properties for an import operation
    ImportRequest:
      properties:
        databaseName:
          type: string
          description: The name of the database to import.
        edition:
          type: string
          description: '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:


            ```azurecli

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

            ````


            ```powershell

            Get-AzSqlServerServiceObjective -Location <location>

            ````

            '
          enum:
          - Web
          - Business
          - Basic
          - Standard
          - Premium
          - PremiumRS
          - Free
          - Stretch
          - DataWarehouse
          - System
          - System2
          - GeneralPurpose
          - BusinessCritical
          - Hyperscale
          x-ms-enum:
            name: DatabaseEdition
            modelAsString: true
        serviceObjectiveName:
          type: string
          description: The name of the service objective to assign to the database.
          enum:
          - System
          - System0
          - System1
          - System2
          - System3
          - System4
          - System2L
          - System3L
          - System4L
          - Free
          - Basic
          - S0
          - S1
          - S2
          - S3
          - S4
          - S6
          - S7
          - S9
          - S12
          - P1
          - P2
          - P3
          - P4
          - P6
          - P11
          - P15
          - PRS1
          - PRS2
          - PRS4
          - PRS6
          - DW100
          - DW200
          - DW300
          - DW400
          - DW500
          - DW600
          - DW1000
          - DW1200
          - DW1000c
          - DW1500
          - DW1500c
          - DW2000
          - DW2000c
          - DW3000
          - DW2500c
          - DW3000c
          - DW6000
          - DW5000c
          - DW6000c
          - DW7500c
          - DW10000c
          - DW15000c
          - DW30000c
          - DS100
          - DS200
          - DS300
          - DS400
          - DS500
          - DS600
          - DS1000
          - DS1200
          - DS1500
          - DS2000
          - ElasticPool
          x-ms-enum:
            modelAsString: true
            name: ServiceObjectiveName
        maxSizeBytes:
          type: string
          description: The maximum size for the newly imported database.
      allOf:
      - $ref: '#/components/schemas/ExportRequest'
      required:
      - databaseName
      - edition
      - serviceObjectiveName
      - maxSizeBytes
      description: Import database parameters.
    ImportExportResponse:
      properties:
        properties:
          $ref: '#/components/schemas/ImportExportResponseProperties'
          x-ms-client-flatten: true
          description: The import/export operation properties.
      allOf:
      - $ref: ../../../common/v1/types.json#/definitions/ProxyResource
      description: Response for Import/Export Get operation.
    ImportExportResponseProperties:
      properties:
        requestType:
          type: string
          readOnly: true
          description: The request type of the operation.
        requestId:
          type: string
          format: uuid
          readOnly: true
          description: The request type of the operation.
        serverName:
          type: string
          readOnly: true
          description: The name of the server.
        databaseName:
          type: string
          readOnly: true
          description: The name of the database.
        status:
          type: string
          readOnly: true
          description: The status message returned from the server.
        lastModifiedTime:
          type: string
          readOnly: true
          description: The operation status last modified time.
        queuedTime:
          type: string
          readOnly: true
          description: The operation queued time.
        blobUri:
          type: string
          readOnly: true
          description: The blob uri.
        errorMessage:
          type: string
          readOnly: true
          description: The error message returned from the server.
      description: Response for Import/Export Status operation.
    ImportExtensionRequest:
      properties:
        name:
          type: string
          description: The name of the extension.
        type:
          type: string
          description: The type of the extension.
        properties:
          $ref: '#/components/schemas/ImportExtensionProperties'
          x-ms-client-flatten: true
          description: Represents the properties of the resource.
      description: Import database parameters.
  parameters:
    ServerNameParameter:
      name: serverName
      in: path
      required: true
      description: The name of the server.
      x-ms-parameter-location: method
      schema:
        type: string
  securitySchemes:
    azure_auth:
      type: oauth2
      flows:
        implicit:
          scopes:
            user_impersonation: impersonate your user account
          authorizationUrl: https://login.microsoftonline.com/common/oauth2/authorize
      description: Azure Active Directory OAuth2 Flow