# SQL Database

Source: /azure/services/sql/

## Introduction

Azure SQL is a managed relational database service for building cloud-native applications with familiar SQL Server tooling.
It supports creating logical servers, provisioning databases, and configuring operational features such as firewall access and retention policies.
This makes it a common choice for transactional workloads and application backends. For more information, see [What is Azure SQL Database?](https://learn.microsoft.com/azure/azure-sql/database/sql-database-paas-overview).

LocalStack for Azure provides a local environment for building and testing applications that make use of Azure SQL Database.
Each logical server you create is backed by a real SQL Server instance, so your application runs its own T-SQL against a real database engine, and every connection is encrypted with a certificate the client can validate.
The supported APIs are listed in the [API Coverage](#api-coverage) section.

## Getting started

This guide is designed for users new to Azure SQL Database and assumes basic knowledge of the Azure CLI and `lstk az`. The following example creates a SQL server and database, configures firewall access, and defines retention and encryption settings.

:::note
Each logical server you create runs a Microsoft SQL Server container, so you must accept the [SQL Server End-User Licensing Agreement](https://go.microsoft.com/fwlink/?LinkId=746388) before the emulator provisions one.
Start the emulator with `MSSQL_ACCEPT_EULA` set to `Y`:

```bash
LOCALSTACK_MSSQL_ACCEPT_EULA=Y lstk start
```

Host variables prefixed with `LOCALSTACK_` are forwarded to the emulator, so the container receives `MSSQL_ACCEPT_EULA=Y`.

To accept it once rather than on every start, add it to an environment profile in your `lstk` config:

```toml
[[containers]]
type = "azure"
tag  = "latest"
port = "4566"
env  = ["mssql"]

[env.mssql]
MSSQL_ACCEPT_EULA = "Y"
```

A profile's values are injected into the container directly, so the `LOCALSTACK_` prefix is not used here.
`lstk` reads the first `config.toml` it finds, starting with `./.lstk/config.toml` in the current directory and then `$HOME/.config/lstk/config.toml`.
See [Config file search order](/azure/developer-tools/running-localstack/lstk/configuration/#config-file-search-order) for the full list and [Passing environment variables to the container](/azure/developer-tools/running-localstack/lstk/configuration/#passing-environment-variables-to-the-container) for how profiles work.

If you start the emulator with the `docker` CLI or Docker Compose, set `MSSQL_ACCEPT_EULA=Y` directly in the container environment instead.
Without it, `az sql server create` fails with `(EulaNotAccepted)`.
:::

Launch LocalStack using your preferred method. For more information, see [Introduction to LocalStack for Azure](/azure/getting-started/). Once the container is running, enable Azure CLI interception by running:

```bash
lstk az start-interception
```

This command points the `az` CLI away from the public Azure management REST API and toward the LocalStack for Azure emulator API.
To revert this configuration, run:

```bash
lstk az stop-interception
```

This reconfigures the `az` CLI to send commands to the official Azure management REST API.

### Create a resource group

Create a resource group to contain your SQL resources:

```bash
az group create --name rg-sql-demo --location westeurope
```

```bash title="Output"
{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo",
  "location": "westeurope",
  "name": "rg-sql-demo",
  "properties": {
    "provisioningState": "Succeeded"
  },
  ...
}
```

### Create and inspect a SQL server

Create a logical SQL server to host your databases:

```bash
az sql server create \
  --name sqlsrvdoc85 \
  --resource-group rg-sql-demo \
  --location westeurope \
  --admin-user lsadmin \
  --admin-password "LocalstackSqlPassw0rd"
```

```bash title="Output"
{
  "administratorLogin": "lsadmin",
  ...
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo/providers/Microsoft.Sql/servers/sqlsrvdoc85",
  ...
  "location": "westeurope",
  ...
  "name": "sqlsrvdoc85",
 ...
  "type": "Microsoft.Sql/servers",
 ...
}
```

Get the SQL server details to verify it is ready:

```bash
az sql server show --name sqlsrvdoc85 --resource-group rg-sql-demo
```

```bash title="Output"
{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo/providers/Microsoft.Sql/servers/sqlsrvdoc85",
  "name": "sqlsrvdoc85",
  "location": "westeurope",
  "state": "Ready",
  "publicNetworkAccess": "Enabled",
  "type": "Microsoft.Sql/servers",
  ...
}
```

### Create and query a database

Create a database on the SQL server:

```bash
az sql db create \
	--name sqldbdoc85 \
	--resource-group rg-sql-demo \
	--server sqlsrvdoc85 \
	--service-objective S0 \
	--compute-model Provisioned
```

```bash title="Output"
{
  ...
  "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
  "collation": "SQL_Latin1_General_CP1_CI_AS",
  "creationDate": "2026-03-24T09:32:54.177434+00:00",
  "currentBackupStorageRedundancy": "Geo",
  "currentServiceObjectiveName": "GP_Gen5_2",
  "currentSku": {
    "capacity": 2,
    "family": "Gen5",
    "name": "S0",
    "size": null,
    "tier": "GeneralPurpose"
  },
  "databaseId": "62951a4b-e3b7-41ce-b7e7-1d4860801828",
  ...
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo/providers/Microsoft.Sql/servers/sqlsrvdoc85/databases/sqldbdoc85",
  ...
  "name": "sqldbdoc85",
  ...
  "sku": {
    "capacity": 2,
    "family": "Gen5",
    "name": "S0",
    "size": null,
    "tier": "GeneralPurpose"
  },
  ...
  "status": "Online",
  ...
}
```

Verify the database status to confirm successful creation:

```bash
az sql db show \
	--name sqldbdoc85 \
	--server sqlsrvdoc85 \
	--resource-group rg-sql-demo
```

```bash title="Output"
{
  ...
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo/providers/Microsoft.Sql/servers/sqlsrvdoc85/databases/sqldbdoc85",
  ...
  "name": "sqldbdoc85",
  ...
  "status": "Online",
  ...
}
```

List the databases on the SQL server:

```bash
az sql db list \
	--resource-group rg-sql-demo \
	--server sqlsrvdoc85
```

```bash title="Output"
[
  {
    ...
    "name": "master",
    ...
  },
  {
    ...
    "name": "sqldbdoc85",
    ...
  }
]
```

### Add a firewall rule

Create a firewall rule to allow client access:

```bash
az sql server firewall-rule create \
  --resource-group rg-sql-demo \
  --server sqlsrvdoc85 \
  --name AllowLocal \
  --start-ip-address 0.0.0.0 \
  --end-ip-address 255.255.255.255
```

```bash title="Output"
{
  "name": "AllowLocal",
  "startIpAddress": "0.0.0.0",
  "endIpAddress": "255.255.255.255",
  "type": "Microsoft.Sql/servers/firewallRules",
  ...
}
```

### Connect to a database

Read the endpoint from the server and export it for reuse as the driver's server value:

```bash
export SQL_SERVER=$(az sql server show --name sqlsrvdoc85 --resource-group rg-sql-demo --query fullyQualifiedDomainName --output tsv)
echo "$SQL_SERVER"
```

```bash title="Output"
sqlsrvdoc85.azure.localhost.localstack.cloud,4510
```

The endpoint carries the port that the emulator listens on for this server, which is why it is used as it comes.
With `sqlcmd` or any ODBC client, that is the `-S` or `SERVER` value:

```bash
sqlcmd -S "$SQL_SERVER" -U lsadmin -P "LocalstackSqlPassw0rd" -d sqldbdoc85 -Q "SELECT 1 AS connected"
```

```bash title="Output"
connected
-----------
          1

(1 row affected)
```

Connections are encrypted and the server certificate validates against the LocalStack public certificate chain, so a client with default settings connects without further configuration, as it does against Azure:

```python
import os
import pyodbc

connection = pyodbc.connect(
    "DRIVER={ODBC Driver 18 for SQL Server};"
    f"SERVER={os.environ['SQL_SERVER']};"
    "DATABASE=sqldbdoc85;UID=lsadmin;"
    f"PWD={os.environ['SQL_PASSWORD']};Encrypt=yes;"
)
```

`TrustServerCertificate=yes` is not needed. It becomes necessary only when LocalStack cannot download its public certificate, for example with `SKIP_SSL_CERT_DOWNLOAD=1` or without outbound network access: the server then presents a certificate issued by the LocalStack root certificate authority and logs a warning naming the server. In that case, either install that root certificate on the client or set `TrustServerCertificate=yes`.

The firewall rule created in the previous section is what lets this connection through. A logical server accepts no client until something admits it, exactly as on Azure, so without a firewall rule, a virtual network rule or an approved private endpoint the login is refused.

### Configure transparent data encryption

Enable transparent data encryption on the database:

```bash
az sql db tde set \
	--database sqldbdoc85 \
	--server sqlsrvdoc85 \
	--resource-group rg-sql-demo \
	--status Enabled
```

```bash title="Output"
{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo/providers/Microsoft.Sql/servers/sqlsrvdoc85/databases/sqldbdoc85/transparentDataEncryption/current",
  "name": "current",
  "resourceGroup": "rg-sql-demo",
  ...
  "state": "Enabled",
  "type": "Microsoft.Sql/servers/databases/transparentDataEncryption"
...
}
```

### Configure backup retention policies

Configure a short-term backup retention policy:

```bash
az sql db str-policy set \
	--name sqldbdoc85 \
	--server sqlsrvdoc85 \
	--resource-group rg-sql-demo \
	--retention-days 7 \
	--diffbackup-hours 24
```

```bash title="Output"
{
  "diffBackupIntervalInHours": 24,
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo/providers/Microsoft.Sql/servers/sqlsrvdoc85/databases/sqldbdoc85/backupShortTermRetentionPolicies/default",
  "name": "default",
  "resourceGroup": "rg-sql-demo",
  "retentionDays": 7,
  "type": "Microsoft.Sql/servers/databases/backupShortTermRetentionPolicies"
...
}
```

Configure a long-term backup retention policy:

```bash
az sql db ltr-policy set \
	--name sqldbdoc85 \
	--server sqlsrvdoc85 \
	--resource-group rg-sql-demo \
	--weekly-retention "P4W" \
	--monthly-retention "P12M" \
	--yearly-retention "P5Y" \
	--week-of-year 16
```

```bash title="Output"
{
  "id": "/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/rg-sql-demo/providers/Microsoft.Sql/servers/sqlsrvdoc85/databases/sqldbdoc85/backupLongTermRetentionPolicies/default",
  "monthlyRetention": "P12M",
  "name": "default",
  "resourceGroup": "rg-sql-demo",
  "timeBasedImmutability": null,
  "timeBasedImmutabilityMode": null,
  "type": "Microsoft.Sql/servers/databases/backupLongTermRetentionPolicies",
  "weekOfYear": 16,
  "weeklyRetention": "P4W",
  "yearlyRetention": "P5Y"
...
}
```

## Features

The Azure SQL emulator supports the following features:

- **Server lifecycle management**: Create, update, delete, get, and list logical SQL servers.
- **Database CRUD**: Create, update, delete, get, list, and rename databases on a logical server.
- **Firewall rules**: Create, update, delete, get, and list server-level firewall rules.
- **Transparent data encryption (TDE)**: Create or update, get, and list TDE configurations per database.
- **Short-term backup retention policies**: Create or update, get, update, and list short-term retention policies per database.
- **Long-term backup retention policies**: Create or update, get, and list long-term retention policies per database.
- **Database security alert policies**: Create or update, get, and list security alert policies per database.
- **Server connection policies**: Create or update, get, and list connection policies per server.
- **SQL vulnerability assessments**: Create or update, get, and list vulnerability assessment settings per server.
- **Database schema introspection**: Get and list schemas, tables, and columns by querying the live SQL Server instance.
- **Server name availability check**: Check whether a server name is available for use.
- **Elastic pools**: Create, update, delete, get, list, and fail over elastic pools, list the databases in a pool, and move a database in and out of one. A pooled database reports the pool's tier, and a pool cannot be deleted while a database still belongs to it.
- **Failover groups**: Create, update, delete, get, list, and the three failover actions. A database added to a group gets a secondary of the same name on the partner server, and both report the replication link.
- **Server identity**: A system-assigned or user-assigned managed identity on the logical server, backed by a real principal that survives a repeated deployment, which is what makes role assignments on it stay valid.
- **Microsoft Entra administrators**: Create or update, get, list, and delete the Entra administrator, and enable or disable Entra-only authentication.
- **Virtual network rules**: Create or update, get, list, and delete virtual network rules against a subnet with the `Microsoft.Sql` service endpoint.
- **Private endpoints**: Private endpoint connections on the server, including approving and rejecting them, plus the private link resource.
- **Server keys and the encryption protector**: Register an Azure Key Vault key on the server and make it the transparent data encryption protector, or return to the service-managed key.
- **Auditing**: Server and database blob auditing policies, plain and extended.
- **Advanced threat protection**: Server and database advanced threat protection settings, and the server security alert policy.
- **Capabilities and operations**: The SKUs and editions available in a location, and the list of operations the provider implements.
- **Database compute management**: Update a database in place (PATCH), and pause and resume a serverless database.
- **Restorable dropped databases**: Get and list restorable dropped databases (stub: always returns an empty list).
- **Asynchronous provisioning**: Server and database creation use async operations with polling headers, matching real Azure behavior.

## Limitations

- **Data does not survive a restart**: The SQL Server container is not part of an exported state. After a state import the emulator recreates each server and its databases, and logs a warning that the databases come back empty.
- **The endpoint is not an Azure host name**: `fullyQualifiedDomainName` is `{server}.azure.localhost.localstack.cloud,{port}`, not `{server}.database.windows.net`, and it embeds the port. Use the value the API returns rather than building a host name yourself.
- **Network rules are not matched against the client address**: The emulator admits a client once the server has any allow path (a firewall rule, a virtual network rule or an approved private endpoint) instead of comparing the client's address with the rule, because the address it sees is the local machine or the Docker gateway. With `publicNetworkAccess` disabled, only an approved private endpoint admits. A refused connection is closed before it reaches the engine, so the client reports a connection failure rather than Azure's login errors 40615 and 47073.
- **`minimalTlsVersion` is not enforced above TLS 1.2**: The value is stored and returned, and the wire allows TLS 1.2, because the SQL Server 2022 image negotiates TLS 1.3 only with TDS 8 strict clients.
- **Microsoft Entra-only authentication is control plane only**: The setting is stored, returned and validated, but the engine still accepts the SQL administrator login.
- **Backup retention policies are metadata-only**: Short-term and long-term retention policies are stored but no backup or restore is performed.
- **Transparent data encryption is metadata-only**: The state, the registered keys and the encryption protector are stored, but no database file is encrypted and no key is used to wrap anything.
- **Security alert policies, vulnerability assessments and advanced threat protection are metadata-only**: The settings are stored but no scan runs and no alert is raised.
- **Server connection policies are metadata-only**: The policy is stored but does not change how a client reaches the server.
- **A failover group replicates no data**: The secondary database is created with the primary's shape and stays empty, and the replication link reports a healthy state.
- **Elastic pool failover is a no-op**: The operation checks the pool and succeeds; there is no replica to fail over to.
- **MSSQL EULA acceptance required**: Each logical server runs a Microsoft SQL Server container, so the `MSSQL_ACCEPT_EULA` environment variable must be set to `Y` before creating any SQL server. Azure asks for no such acceptance. See [Getting started](#getting-started) for how to set it.

## Configuration

The behavior of the Azure SQL emulator can be customized using the environment variables listed below.

| **Variable**                           | **Description**                                                                                           | **Type** | **Default** |
| -------------------------------------- | --------------------------------------------------------------------------------------------------------- | -------- | ----------- |
| `MSSQL_ACCEPT_EULA`                   | Accept the Microsoft SQL Server [End-User Licensing Agreement](https://go.microsoft.com/fwlink/?LinkId=746388). Must be set to `Y` to create SQL servers. On the command line, use `LOCALSTACK_MSSQL_ACCEPT_EULA=Y lstk start`. | String   | (unset)     |
| `ALLOW_MULTIPLE_SQL_SERVER_DEPLOYMENTS`| Allow provisioning more than one SQL Server Docker container. Set to `1` or `true` to enable.             | Boolean  | `0`         |
| `LS_AZURE_MSSQL_IMAGE`                | The SQL Server image each logical server runs.                                                            | String   | `mcr.microsoft.com/mssql/server:2022-latest` |
| `SKIP_SSL_CERT_DOWNLOAD`              | Skip downloading the LocalStack public certificate. Servers then present a certificate issued by the LocalStack root certificate authority, so clients need that authority or `TrustServerCertificate=yes`. | Boolean | `0` |

## Samples

The following samples demonstrate how to use Azure SQL Database with LocalStack for Azure:

- [Web App and SQL Database (Python)](https://github.com/localstack/localstack-azure-samples/tree/main/samples/web-app-sql-database/python)
- [Web App and SQL Database (.NET)](https://github.com/localstack/localstack-azure-samples/tree/main/samples/web-app-sql-database/dotnet)
- [Web App on AKS and SQL Database (Python)](https://github.com/localstack-samples/aks-samples/tree/main/samples/web-app-sql-database/python)
- [Web App on AKS and SQL Database (.NET)](https://github.com/localstack-samples/aks-samples/tree/main/samples/web-app-sql-database/dotnet)

## API Coverage


### SQL Database API coverage

Source service: `sql`. 111 of 392 tracked operations are implemented.

Service documentation: /azure/services/sql/

| Operation | Status |
| --- | --- |
| BackupShortTermRetentionPolicies.CreateOrUpdate | Implemented |
| BackupShortTermRetentionPolicies.Get | Implemented |
| BackupShortTermRetentionPolicies.ListByDatabase | Implemented |
| BackupShortTermRetentionPolicies.Update | Implemented |
| Capabilities.ListByLocation | Implemented |
| DataMaskingPolicies.CreateOrUpdate | Not implemented |
| DataMaskingPolicies.Get | Not implemented |
| DataMaskingRules.CreateOrUpdate | Not implemented |
| DataMaskingRules.ListByDatabase | Not implemented |
| DataWarehouseUserActivities.Get | Not implemented |
| DataWarehouseUserActivities.ListByDatabase | Not implemented |
| DatabaseAdvancedThreatProtectionSettings.CreateOrUpdate | Implemented |
| DatabaseAdvancedThreatProtectionSettings.Get | Implemented |
| DatabaseAdvancedThreatProtectionSettings.ListByDatabase | Implemented |
| DatabaseAdvisors.CreateOrUpdate | Not implemented |
| DatabaseAdvisors.Get | Not implemented |
| DatabaseAdvisors.ListByDatabase | Not implemented |
| DatabaseAdvisors.Update | Not implemented |
| DatabaseAutomaticTuning.Get | Not implemented |
| DatabaseAutomaticTuning.Update | Not implemented |
| DatabaseBlobAuditingPolicies.CreateOrUpdate | Implemented |
| DatabaseBlobAuditingPolicies.Get | Implemented |
| DatabaseBlobAuditingPolicies.ListByDatabase | Implemented |
| DatabaseColumns.Get | Implemented |
| DatabaseColumns.ListByDatabase | Not implemented |
| DatabaseColumns.ListByTable | Implemented |
| DatabaseConnectionPolicies.CreateOrUpdate | Not implemented |
| DatabaseConnectionPolicies.Get | Not implemented |
| DatabaseEncryptionProtectors.Revalidate | Not implemented |
| DatabaseEncryptionProtectors.Revert | Not implemented |
| DatabaseExtensions.CreateOrUpdate | Not implemented |
| DatabaseExtensions.Get | Not implemented |
| DatabaseExtensions.ListByDatabase | Not implemented |
| DatabaseOperations.Cancel | Not implemented |
| DatabaseOperations.ListByDatabase | Not implemented |
| DatabaseRecommendedActions.Get | Not implemented |
| DatabaseRecommendedActions.ListByDatabaseAdvisor | Not implemented |
| DatabaseRecommendedActions.Update | Not implemented |
| DatabaseSchemas.Get | Implemented |
| DatabaseSchemas.ListByDatabase | Implemented |
| DatabaseSecurityAlertPolicies.CreateOrUpdate | Implemented |
| DatabaseSecurityAlertPolicies.Get | Implemented |
| DatabaseSecurityAlertPolicies.ListByDatabase | Implemented |
| DatabaseSqlVulnerabilityAssessmentBaselines.CreateOrUpdate | Not implemented |
| DatabaseSqlVulnerabilityAssessmentBaselines.Get | Not implemented |
| DatabaseSqlVulnerabilityAssessmentBaselines.ListBySqlVulnerabilityAssessment | Not implemented |
| DatabaseSqlVulnerabilityAssessmentExecuteScan.Execute | Not implemented |
| DatabaseSqlVulnerabilityAssessmentRuleBaselines.CreateOrUpdate | Not implemented |
| DatabaseSqlVulnerabilityAssessmentRuleBaselines.Delete | Not implemented |
| DatabaseSqlVulnerabilityAssessmentRuleBaselines.Get | Not implemented |
| DatabaseSqlVulnerabilityAssessmentRuleBaselines.ListByBaseline | Not implemented |
| DatabaseSqlVulnerabilityAssessmentScanResult.Get | Not implemented |
| DatabaseSqlVulnerabilityAssessmentScanResult.ListByScan | Not implemented |
| DatabaseSqlVulnerabilityAssessmentScans.Get | Not implemented |
| DatabaseSqlVulnerabilityAssessmentScans.ListBySqlVulnerabilityAssessments | Not implemented |
| DatabaseSqlVulnerabilityAssessmentsSettings.Get | Not implemented |
| DatabaseSqlVulnerabilityAssessmentsSettings.ListByDatabase | Not implemented |
| DatabaseTableAuditingPolicies.CreateOrUpdate | Not implemented |
| DatabaseTableAuditingPolicies.Get | Not implemented |
| DatabaseTableAuditingPolicies.ListByDatabase | Not implemented |
| DatabaseTables.Get | Implemented |
| DatabaseTables.ListBySchema | Implemented |
| DatabaseUsages.ListByDatabase | Not implemented |
| DatabaseVulnerabilityAssessmentRuleBaselines.CreateOrUpdate | Not implemented |
| DatabaseVulnerabilityAssessmentRuleBaselines.Delete | Not implemented |
| DatabaseVulnerabilityAssessmentRuleBaselines.Get | Not implemented |
| DatabaseVulnerabilityAssessmentScans.Export | Not implemented |
| DatabaseVulnerabilityAssessmentScans.Get | Not implemented |
| DatabaseVulnerabilityAssessmentScans.InitiateScan | Not implemented |
| DatabaseVulnerabilityAssessmentScans.ListByDatabase | Not implemented |
| DatabaseVulnerabilityAssessments.CreateOrUpdate | Not implemented |
| DatabaseVulnerabilityAssessments.Delete | Not implemented |
| DatabaseVulnerabilityAssessments.Get | Not implemented |
| DatabaseVulnerabilityAssessments.ListByDatabase | Not implemented |
| Databases.CreateOrUpdate | Implemented |
| Databases.Delete | Implemented |
| Databases.Export | Not implemented |
| Databases.Failover | Not implemented |
| Databases.Get | Implemented |
| Databases.GetByElasticPool | Not implemented |
| Databases.GetByRecommendedElasticPool | Not implemented |
| Databases.Import | Not implemented |
| Databases.ListByElasticPool | Implemented |
| Databases.ListByRecommendedElasticPool | Not implemented |
| Databases.ListByServer | Implemented |
| Databases.ListInaccessibleByServer | Not implemented |
| Databases.ListMetricDefinitions | Not implemented |
| Databases.ListMetrics | Not implemented |
| Databases.Pause | Implemented |
| Databases.Rename | Implemented |
| Databases.Resume | Implemented |
| Databases.Update | Implemented |
| Databases.UpgradeDataWarehouse | Not implemented |
| DeletedServers.Get | Not implemented |
| DeletedServers.List | Not implemented |
| DeletedServers.ListByLocation | Not implemented |
| DeletedServers.Recover | Not implemented |
| DisasterRecoveryConfigurations.CreateOrUpdate | Not implemented |
| DisasterRecoveryConfigurations.Delete | Not implemented |
| DisasterRecoveryConfigurations.Failover | Not implemented |
| DisasterRecoveryConfigurations.FailoverAllowDataLoss | Not implemented |
| DisasterRecoveryConfigurations.Get | Not implemented |
| DisasterRecoveryConfigurations.List | Not implemented |
| ElasticPoolActivities.ListByElasticPool | Not implemented |
| ElasticPoolDatabaseActivities.ListByElasticPool | Not implemented |
| ElasticPoolOperations.Cancel | Not implemented |
| ElasticPoolOperations.ListByElasticPool | Not implemented |
| ElasticPools.CreateOrUpdate | Implemented |
| ElasticPools.Delete | Implemented |
| ElasticPools.Failover | Implemented |
| ElasticPools.Get | Implemented |
| ElasticPools.ListByServer | Implemented |
| ElasticPools.ListMetricDefinitions | Not implemented |
| ElasticPools.ListMetrics | Not implemented |
| ElasticPools.Update | Implemented |
| EncryptionProtectors.CreateOrUpdate | Implemented |
| EncryptionProtectors.Get | Implemented |
| EncryptionProtectors.ListByServer | Implemented |
| EncryptionProtectors.Revalidate | Implemented |
| ExtendedDatabaseBlobAuditingPolicies.CreateOrUpdate | Implemented |
| ExtendedDatabaseBlobAuditingPolicies.Get | Implemented |
| ExtendedDatabaseBlobAuditingPolicies.ListByDatabase | Implemented |
| ExtendedServerBlobAuditingPolicies.CreateOrUpdate | Implemented |
| ExtendedServerBlobAuditingPolicies.Get | Implemented |
| ExtendedServerBlobAuditingPolicies.ListByServer | Implemented |
| FailoverGroups.CreateOrUpdate | Implemented |
| FailoverGroups.Delete | Implemented |
| FailoverGroups.Failover | Implemented |
| FailoverGroups.ForceFailoverAllowDataLoss | Implemented |
| FailoverGroups.Get | Implemented |
| FailoverGroups.ListByServer | Implemented |
| FailoverGroups.TryPlannedBeforeForcedFailover | Implemented |
| FailoverGroups.Update | Implemented |
| FirewallRules.CreateOrUpdate | Implemented |
| FirewallRules.Delete | Implemented |
| FirewallRules.Get | Implemented |
| FirewallRules.ListByServer | Implemented |
| FirewallRules.Replace | Not implemented |
| GeoBackupPolicies.CreateOrUpdate | Not implemented |
| GeoBackupPolicies.Get | Not implemented |
| GeoBackupPolicies.List | Not implemented |
| Ipv6FirewallRules.CreateOrUpdate | Not implemented |
| Ipv6FirewallRules.Delete | Not implemented |
| Ipv6FirewallRules.Get | Not implemented |
| Ipv6FirewallRules.ListByServer | Not implemented |
| JobAgents.CreateOrUpdate | Not implemented |
| JobAgents.Delete | Not implemented |
| JobAgents.Get | Not implemented |
| JobAgents.ListByServer | Not implemented |
| JobAgents.Update | Not implemented |
| JobCredentials.CreateOrUpdate | Not implemented |
| JobCredentials.Delete | Not implemented |
| JobCredentials.Get | Not implemented |
| JobCredentials.ListByAgent | Not implemented |
| JobExecutions.Cancel | Not implemented |
| JobExecutions.Create | Not implemented |
| JobExecutions.CreateOrUpdate | Not implemented |
| JobExecutions.Get | Not implemented |
| JobExecutions.ListByAgent | Not implemented |
| JobExecutions.ListByJob | Not implemented |
| JobPrivateEndpoints.CreateOrUpdate | Not implemented |
| JobPrivateEndpoints.Delete | Not implemented |
| JobPrivateEndpoints.Get | Not implemented |
| JobPrivateEndpoints.ListByAgent | Not implemented |
| JobStepExecutions.Get | Not implemented |
| JobStepExecutions.ListByJobExecution | Not implemented |
| JobSteps.CreateOrUpdate | Not implemented |
| JobSteps.Delete | Not implemented |
| JobSteps.Get | Not implemented |
| JobSteps.GetByVersion | Not implemented |
| JobSteps.ListByJob | Not implemented |
| JobSteps.ListByVersion | Not implemented |
| JobTargetExecutions.Get | Not implemented |
| JobTargetExecutions.ListByJobExecution | Not implemented |
| JobTargetExecutions.ListByStep | Not implemented |
| JobTargetGroups.CreateOrUpdate | Not implemented |
| JobTargetGroups.Delete | Not implemented |
| JobTargetGroups.Get | Not implemented |
| JobTargetGroups.ListByAgent | Not implemented |
| JobVersions.Get | Not implemented |
| JobVersions.ListByJob | Not implemented |
| Jobs.CreateOrUpdate | Not implemented |
| Jobs.Delete | Not implemented |
| Jobs.Get | Not implemented |
| Jobs.ListByAgent | Not implemented |
| LedgerDigestUploads.CreateOrUpdate | Not implemented |
| LedgerDigestUploads.Disable | Not implemented |
| LedgerDigestUploads.Get | Not implemented |
| LedgerDigestUploads.ListByDatabase | Not implemented |
| LongTermRetentionBackups.ChangeAccessTier | Not implemented |
| LongTermRetentionBackups.ChangeAccessTierByResourceGroup | Not implemented |
| LongTermRetentionBackups.Copy | Not implemented |
| LongTermRetentionBackups.CopyByResourceGroup | Not implemented |
| LongTermRetentionBackups.Delete | Not implemented |
| LongTermRetentionBackups.DeleteByResourceGroup | Not implemented |
| LongTermRetentionBackups.Get | Not implemented |
| LongTermRetentionBackups.GetByResourceGroup | Not implemented |
| LongTermRetentionBackups.ListByDatabase | Not implemented |
| LongTermRetentionBackups.ListByLocation | Not implemented |
| LongTermRetentionBackups.ListByResourceGroupDatabase | Not implemented |
| LongTermRetentionBackups.ListByResourceGroupLocation | Not implemented |
| LongTermRetentionBackups.ListByResourceGroupServer | Not implemented |
| LongTermRetentionBackups.ListByServer | Not implemented |
| LongTermRetentionBackups.LockTimeBasedImmutability | Not implemented |
| LongTermRetentionBackups.LockTimeBasedImmutabilityByResourceGroup | Not implemented |
| LongTermRetentionBackups.RemoveLegalHoldImmutability | Not implemented |
| LongTermRetentionBackups.RemoveLegalHoldImmutabilityByResourceGroup | Not implemented |
| LongTermRetentionBackups.RemoveTimeBasedImmutability | Not implemented |
| LongTermRetentionBackups.RemoveTimeBasedImmutabilityByResourceGroup | Not implemented |
| LongTermRetentionBackups.SetLegalHoldImmutability | Not implemented |
| LongTermRetentionBackups.SetLegalHoldImmutabilityByResourceGroup | Not implemented |
| LongTermRetentionBackups.Update | Not implemented |
| LongTermRetentionBackups.UpdateByResourceGroup | Not implemented |
| LongTermRetentionPolicies.CreateOrUpdate | Implemented |
| LongTermRetentionPolicies.Get | Implemented |
| LongTermRetentionPolicies.ListByDatabase | Implemented |
| MaintenanceWindowOptions.Get | Not implemented |
| MaintenanceWindows.CreateOrUpdate | Not implemented |
| MaintenanceWindows.Get | Not implemented |
| NetworkSecurityPerimeterConfigurations.Get | Not implemented |
| NetworkSecurityPerimeterConfigurations.ListByServer | Not implemented |
| NetworkSecurityPerimeterConfigurations.Reconcile | Not implemented |
| Operations.List | Implemented |
| OutboundFirewallRules.CreateOrUpdate | Not implemented |
| OutboundFirewallRules.Delete | Not implemented |
| OutboundFirewallRules.Get | Not implemented |
| OutboundFirewallRules.ListByServer | Not implemented |
| PrivateEndpointConnections.CreateOrUpdate | Implemented |
| PrivateEndpointConnections.Delete | Implemented |
| PrivateEndpointConnections.Get | Implemented |
| PrivateEndpointConnections.ListByServer | Implemented |
| PrivateLinkResources.Get | Implemented |
| PrivateLinkResources.ListByServer | Implemented |
| Queries.ListByDatabase | Not implemented |
| QueryStatistics.ListByQuery | Not implemented |
| QueryTexts.ListByQuery | Not implemented |
| RecommendedElasticPools.Get | Not implemented |
| RecommendedElasticPools.ListByServer | Not implemented |
| RecommendedElasticPools.ListMetrics | Not implemented |
| RecommendedSensitivityLabels.Update | Not implemented |
| RecoverableDatabases.Get | Not implemented |
| RecoverableDatabases.ListByServer | Not implemented |
| ReplicationLinks.CreateOrUpdate | Not implemented |
| ReplicationLinks.Delete | Not implemented |
| ReplicationLinks.Failover | Not implemented |
| ReplicationLinks.FailoverAllowDataLoss | Not implemented |
| ReplicationLinks.Get | Not implemented |
| ReplicationLinks.ListByDatabase | Implemented |
| ReplicationLinks.ListByServer | Not implemented |
| ReplicationLinks.Unlink | Not implemented |
| ReplicationLinks.Update | Not implemented |
| RestorableDroppedDatabases.Get | Implemented |
| RestorableDroppedDatabases.ListByServer | Implemented |
| RestorePoints.Create | Not implemented |
| RestorePoints.Delete | Not implemented |
| RestorePoints.Get | Not implemented |
| RestorePoints.ListByDatabase | Not implemented |
| SensitivityLabels.CreateOrUpdate | Not implemented |
| SensitivityLabels.Delete | Not implemented |
| SensitivityLabels.DisableRecommendation | Not implemented |
| SensitivityLabels.EnableRecommendation | Not implemented |
| SensitivityLabels.Get | Not implemented |
| SensitivityLabels.ListByDatabase | Not implemented |
| SensitivityLabels.ListCurrentByDatabase | Not implemented |
| SensitivityLabels.ListRecommendedByDatabase | Not implemented |
| SensitivityLabels.Update | Not implemented |
| ServerAdvancedThreatProtectionSettings.CreateOrUpdate | Implemented |
| ServerAdvancedThreatProtectionSettings.Get | Implemented |
| ServerAdvancedThreatProtectionSettings.ListByServer | Implemented |
| ServerAdvisors.CreateOrUpdate | Not implemented |
| ServerAdvisors.Get | Not implemented |
| ServerAdvisors.ListByServer | Not implemented |
| ServerAdvisors.Update | Not implemented |
| ServerAutomaticTuning.Get | Not implemented |
| ServerAutomaticTuning.Update | Not implemented |
| ServerAzureAdAdministrators.CreateOrUpdate | Implemented |
| ServerAzureAdAdministrators.Delete | Implemented |
| ServerAzureAdAdministrators.Get | Implemented |
| ServerAzureAdAdministrators.ListByServer | Implemented |
| ServerAzureAdOnlyAuthentications.CreateOrUpdate | Implemented |
| ServerAzureAdOnlyAuthentications.Delete | Implemented |
| ServerAzureAdOnlyAuthentications.Get | Implemented |
| ServerAzureAdOnlyAuthentications.ListByServer | Implemented |
| ServerBlobAuditingPolicies.CreateOrUpdate | Implemented |
| ServerBlobAuditingPolicies.Get | Implemented |
| ServerBlobAuditingPolicies.ListByServer | Implemented |
| ServerCommunicationLinks.CreateOrUpdate | Not implemented |
| ServerCommunicationLinks.Delete | Not implemented |
| ServerCommunicationLinks.Get | Not implemented |
| ServerCommunicationLinks.ListByServer | Not implemented |
| ServerConnectionPolicies.CreateOrUpdate | Implemented |
| ServerConnectionPolicies.Get | Implemented |
| ServerConnectionPolicies.ListByServer | Implemented |
| ServerDevOpsAuditSettings.CreateOrUpdate | Not implemented |
| ServerDevOpsAuditSettings.Get | Not implemented |
| ServerDevOpsAuditSettings.ListByServer | Not implemented |
| ServerDnsAliases.Acquire | Not implemented |
| ServerDnsAliases.CreateOrUpdate | Not implemented |
| ServerDnsAliases.Delete | Not implemented |
| ServerDnsAliases.Get | Not implemented |
| ServerDnsAliases.ListByServer | Not implemented |
| ServerKeys.CreateOrUpdate | Implemented |
| ServerKeys.Delete | Implemented |
| ServerKeys.Get | Implemented |
| ServerKeys.ListByServer | Implemented |
| ServerOperations.ListByServer | Not implemented |
| ServerSecurityAlertPolicies.CreateOrUpdate | Implemented |
| ServerSecurityAlertPolicies.Get | Implemented |
| ServerSecurityAlertPolicies.ListByServer | Implemented |
| ServerTableAuditingPolicies.CreateOrUpdate | Not implemented |
| ServerTableAuditingPolicies.Get | Not implemented |
| ServerTableAuditingPolicies.ListByServer | Not implemented |
| ServerUsages.ListByServer | Not implemented |
| ServerVulnerabilityAssessments.CreateOrUpdate | Not implemented |
| ServerVulnerabilityAssessments.Delete | Not implemented |
| ServerVulnerabilityAssessments.Get | Not implemented |
| ServerVulnerabilityAssessments.ListByServer | Not implemented |
| Servers.CheckNameAvailability | Implemented |
| Servers.CreateOrUpdate | Implemented |
| Servers.Delete | Implemented |
| Servers.Get | Implemented |
| Servers.ImportDatabase | Not implemented |
| Servers.List | Implemented |
| Servers.ListByResourceGroup | Implemented |
| Servers.RefreshStatus | Not implemented |
| Servers.Update | Implemented |
| ServiceObjectives.Get | Not implemented |
| ServiceObjectives.ListByServer | Not implemented |
| ServiceTierAdvisors.Get | Not implemented |
| ServiceTierAdvisors.ListByDatabase | Not implemented |
| SqlVulnerabilityAssessmentBaseline.Get | Not implemented |
| SqlVulnerabilityAssessmentBaseline.ListBySqlVulnerabilityAssessment | Not implemented |
| SqlVulnerabilityAssessmentBaselines.CreateOrUpdate | Not implemented |
| SqlVulnerabilityAssessmentExecuteScan.Execute | Not implemented |
| SqlVulnerabilityAssessmentRuleBaseline.CreateOrUpdate | Not implemented |
| SqlVulnerabilityAssessmentRuleBaseline.Get | Not implemented |
| SqlVulnerabilityAssessmentRuleBaseline.ListByBaseline | Not implemented |
| SqlVulnerabilityAssessmentRuleBaselines.Delete | Not implemented |
| SqlVulnerabilityAssessmentScanResult.Get | Not implemented |
| SqlVulnerabilityAssessmentScanResult.ListByScan | Not implemented |
| SqlVulnerabilityAssessmentScans.Get | Not implemented |
| SqlVulnerabilityAssessmentScans.ListBySqlVulnerabilityAssessments | Not implemented |
| SqlVulnerabilityAssessments.Delete | Not implemented |
| SqlVulnerabilityAssessmentsSettings.CreateOrUpdate | Implemented |
| SqlVulnerabilityAssessmentsSettings.Get | Implemented |
| SqlVulnerabilityAssessmentsSettings.ListByServer | Implemented |
| SubscriptionUsages.Get | Not implemented |
| SubscriptionUsages.ListByLocation | Not implemented |
| SynapseLinkWorkspaces.ListByDatabase | Not implemented |
| SyncAgents.CreateOrUpdate | Not implemented |
| SyncAgents.Delete | Not implemented |
| SyncAgents.GenerateKey | Not implemented |
| SyncAgents.Get | Not implemented |
| SyncAgents.ListByServer | Not implemented |
| SyncAgents.ListLinkedDatabases | Not implemented |
| SyncGroups.CancelSync | Not implemented |
| SyncGroups.CreateOrUpdate | Not implemented |
| SyncGroups.Delete | Not implemented |
| SyncGroups.Get | Not implemented |
| SyncGroups.ListByDatabase | Not implemented |
| SyncGroups.ListHubSchemas | Not implemented |
| SyncGroups.ListLogs | Not implemented |
| SyncGroups.ListSyncDatabaseIds | Not implemented |
| SyncGroups.RefreshHubSchema | Not implemented |
| SyncGroups.TriggerSync | Not implemented |
| SyncGroups.Update | Not implemented |
| SyncMembers.CreateOrUpdate | Not implemented |
| SyncMembers.Delete | Not implemented |
| SyncMembers.Get | Not implemented |
| SyncMembers.ListBySyncGroup | Not implemented |
| SyncMembers.ListMemberSchemas | Not implemented |
| SyncMembers.RefreshMemberSchema | Not implemented |
| SyncMembers.Update | Not implemented |
| TdeCertificates.Create | Not implemented |
| TransparentDataEncryptionActivities.ListByConfiguration | Not implemented |
| TransparentDataEncryptions.CreateOrUpdate | Implemented |
| TransparentDataEncryptions.Get | Implemented |
| TransparentDataEncryptions.ListByDatabase | Implemented |
| TransparentDataEncryptions.Resume | Not implemented |
| TransparentDataEncryptions.Suspend | Not implemented |
| VirtualNetworkRules.CreateOrUpdate | Implemented |
| VirtualNetworkRules.Delete | Implemented |
| VirtualNetworkRules.Get | Implemented |
| VirtualNetworkRules.ListByServer | Implemented |
| WorkloadClassifiers.CreateOrUpdate | Not implemented |
| WorkloadClassifiers.Delete | Not implemented |
| WorkloadClassifiers.Get | Not implemented |
| WorkloadClassifiers.ListByWorkloadGroup | Not implemented |
| WorkloadGroups.CreateOrUpdate | Not implemented |
| WorkloadGroups.Delete | Not implemented |
| WorkloadGroups.Get | Not implemented |
| WorkloadGroups.ListByDatabase | Not implemented |