Transparent Data Encryptions - Create Or Update

Creates or updates a database's transparent data encryption configuration.

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

URI Parameters

Name In Required Type Description
subscriptionId
path True
  • string

The subscription ID that identifies an Azure subscription.

resourceGroupName
path True
  • string

The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.

serverName
path True
  • string

The name of the server.

databaseName
path True
  • string

The name of the database for which setting the transparent data encryption applies.

transparentDataEncryptionName
path True

The name of the transparent data encryption configuration.

api-version
query True
  • string

The API version to use for the request.

Request Body

Name Required Type Description
status

The status of the database transparent data encryption.

Responses

Name Type Description
200 OK

OK

201 Created

Created

Examples

Create or update a database's transparent data encryption configuration

Sample Request

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-9187/transparentDataEncryption/current?api-version=2014-04-01
{
  "properties": {
    "status": "Enabled"
  }
}

Sample Response

{
  "name": "current",
  "location": "North Europe",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-9187/transparentDataEncryption/current",
  "type": "Microsoft.Sql/servers/databases/transparentDataEncryption",
  "properties": {
    "status": "Enabled"
  }
}
{
  "name": "current",
  "location": "North Europe",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-6852/providers/Microsoft.Sql/servers/sqlcrudtest-2080/databases/sqlcrudtest-9187/transparentDataEncryption/current",
  "type": "Microsoft.Sql/servers/databases/transparentDataEncryption",
  "properties": {
    "status": "Enabled"
  }
}

Definitions

TransparentDataEncryption
TransparentDataEncryptionName

The name of the transparent data encryption configuration.

TransparentDataEncryptionStatus

The status of the database transparent data encryption.

Name Type Description
location
  • string

Resource location.

status

The status of the database transparent data encryption.

The name of the transparent data encryption configuration.

Name Description
current

The status of the database transparent data encryption.

Name Description
Disabled
Enabled