Microsoft.Sql servers/databases/extensions

  • Artikel
  • 2 menit untuk membaca

The servers/databases/extensions resource type can be deployed to: Resource groups.

To learn about resource group deployments, see Bicep or ARM template.

For a list of changed properties in each API version, see change log.

Template format

To create a Microsoft.Sql/servers/databases/extensions resource, add the following Bicep or JSON to your template.

resource symbolicname 'Microsoft.Sql/servers/databases/extensions@2021-11-01-preview' = {
  name: 'string'
  parent: resourceSymbolicName
  properties: {
    administratorLogin: 'string'
    administratorLoginPassword: 'string'
    authenticationType: 'string'
    databaseEdition: 'string'
    maxSizeBytes: 'string'
    networkIsolation: {
      sqlServerResourceId: 'string'
      storageAccountResourceId: 'string'
    }
    operationMode: 'string'
    serviceObjectiveName: 'string'
    storageKey: 'string'
    storageKeyType: 'string'
    storageUri: 'string'
  }
}

Property values

servers/databases/extensions

Name Description Value
type The resource type

For Bicep, set this value in the resource declaration.		 'Microsoft.Sql/servers/databases/extensions'
apiVersion The resource api version

For Bicep, set this value in the resource declaration.		 '2021-11-01-preview'
name The resource name

See how to set names and types for child resources in Bicep or JSON ARM templates.		 string (required)
parent In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource.

For more information, see Child resource outside parent resource.		 Symbolic name for resource of type: databases
properties Resource properties. DatabaseExtensionsProperties

DatabaseExtensionsProperties

Name Description Value
administratorLogin Administrator login name. string
administratorLoginPassword Administrator login password. string
authenticationType Authentication type: SQL authentication or AD password. string
databaseEdition Database edition for the newly created database in the case of an import operation. string
maxSizeBytes Database max size in bytes for the newly created database in the case of an import operation. string
networkIsolation Optional resource information to enable network isolation for request. NetworkIsolationSettings
operationMode Operation mode of the operation: Import, Export, or PolybaseImport. 'Export'
'Import'
'PolybaseImport'
serviceObjectiveName Database service level objective for the newly created database in the case of an import operation. string
storageKey Storage key for the storage account. string (required)
storageKeyType Storage key type: StorageAccessKey or SharedAccessKey. 'SharedAccessKey'
'StorageAccessKey'
storageUri Storage Uri for the storage account. string (required)

NetworkIsolationSettings

Name Description Value
sqlServerResourceId The resource id for the SQL server which is the target of this request. If set, private endpoint connection will be created for the SQL server. Must match server which is target of the operation. string
storageAccountResourceId The resource id for the storage account used to store BACPAC file. If set, private endpoint connection will be created for the storage account. Must match storage account used for StorageUri parameter. string