Databases - Create Or Update

Layanan:: SQL Database

Versi API:: 2025-01-01

Membuat database atau memperbarui database yang ada.

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

Parameter URI

Nama	Dalam	Diperlukan	Jenis	Deskripsi
databaseName	path	True	string	Nama database.
resourceGroupName	path	True	string minLength: 1 maxLength: 90	Nama grup sumber daya. Nama tidak sensitif terhadap penggunaan huruf besar atau kecil.
serverName	path	True	string	Nama server.
subscriptionId	path	True	string (uuid)	ID langganan target. Nilainya harus sebuah UUID.
api-version	query	True	string minLength: 1	Versi API yang akan digunakan untuk operasi ini.

Isi Permintaan

Nama	Diperlukan	Jenis	Deskripsi
location	True	string	Lokasi geografis tempat sumber daya berada
identity		DatabaseIdentity	Identitas Azure Active Directory database.
properties.autoPauseDelay		integer (int32)	Waktu dalam menit setelah database dijeda secara otomatis. Nilai -1 berarti jeda otomatis dinonaktifkan
properties.availabilityZone		AvailabilityZoneType	Menentukan zona ketersediaan tempat database disematkan.
properties.catalogCollation		CatalogCollationType	Kolate katalog metadata.
properties.collation		string	Kolatasi database.
properties.createMode		CreateMode	Menentukan mode pembuatan database. Default: pembuatan database reguler. Salin: membuat database sebagai salinan database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database sumber. Sekunder: membuat database sebagai replika sekunder dari database yang ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya dari database utama yang ada. PointInTimeRestore: Membuat database dengan memulihkan cadangan titik waktu database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang ada, dan restorePointInTime harus ditentukan. Pemulihan: Membuat database dengan memulihkan cadangan yang direplikasi secara geografis. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang dapat dipulihkan untuk dipulihkan. Pemulihan: Membuat database dengan memulihkan cadangan database yang dihapus. sourceDatabaseId harus ditentukan. Jika sourceDatabaseId adalah ID sumber daya asli database, maka sourceDatabaseDeletionDate harus ditentukan. Jika tidak, sourceDatabaseId harus menjadi ID sumber daya database yang dihilangkan dan sourceDatabaseDeletionDate yang dapat diabaikan. restorePointInTime juga dapat ditentukan untuk memulihkan dari titik waktu sebelumnya. RestoreLongTermRetentionBackup: Membuat database dengan memulihkan dari vault retensi jangka panjang. recoveryServicesRecoveryPointResourceId harus ditentukan sebagai ID sumber daya titik pemulihan. Copy, Secondary, dan RestoreLongTermRetentionBackup tidak didukung untuk edisi DataWarehouse.
properties.elasticPoolId		string (arm-id)	Pengidentifikasi sumber daya kumpulan elastis yang berisi database ini.
properties.encryptionProtector		string	URI brankas kunci azure database jika dikonfigurasi dengan per Kunci Terkelola Pelanggan Database.
properties.encryptionProtectorAutoRotation		boolean	Bendera untuk mengaktifkan atau menonaktifkan rotasi otomatis kunci AKV pelindung enkripsi database.
properties.federatedClientId		string (uuid)	Id Klien yang digunakan untuk skenario CMK lintas penyewa per database
properties.freeLimitExhaustionBehavior		FreeLimitExhaustionBehavior	Menentukan perilaku ketika batas gratis bulanan habis untuk database gratis. Jeda Otomatis: Database akan dijeda secara otomatis setelah kelelahan batas gratis selama sisa bulan. BillForUsage: Database akan terus online setelah kelelahan batas gratis dan kelebihan biaya apa pun akan ditagih.
properties.highAvailabilityReplicaCount		integer (int32)	Jumlah replika sekunder yang terkait dengan database edisi Business Critical, Premium, atau Hyperscale yang digunakan untuk memberikan ketersediaan tinggi. Tidak berlaku untuk database Hyperscale dalam kumpulan elastis.
properties.isLedgerOn		boolean	Apakah database ini adalah database ledger atau tidak, yang berarti semua tabel dalam database adalah tabel ledger. Catatan: nilai properti ini tidak dapat diubah setelah database dibuat.
properties.keys		<string, DatabaseKey>	Id sumber daya dari identitas yang ditetapkan pengguna untuk digunakan
properties.licenseType		DatabaseLicenseType	Jenis lisensi yang akan diterapkan untuk database ini. `LicenseIncluded` jika Anda memerlukan lisensi, atau `BasePrice` jika Anda memiliki lisensi dan memenuhi syarat untuk Azure Hybrid Benefit.
properties.longTermRetentionBackupResourceId		string (arm-id)	Pengidentifikasi sumber daya cadangan retensi jangka panjang yang terkait dengan operasi pembuatan database ini.
properties.maintenanceConfigurationId		string	Id konfigurasi pemeliharaan yang ditetapkan ke database. Konfigurasi ini menentukan periode kapan pembaruan pemeliharaan akan terjadi.
properties.manualCutover		boolean	Apakah cutover manual yang dikontrol pelanggan perlu dilakukan selama operasi Pembaruan Database ke tingkat Hyperscale atau tidak. Properti ini hanya berlaku saat menskalakan database dari tingkat Business Critical/General Purpose/Premium/Standard ke tingkat Hyperscale. Ketika manualCutover ditentukan, operasi penskalaan akan menunggu input pengguna untuk memicu cutover ke database Hyperscale. Untuk memicu cutover, harap berikan parameter 'performCutover' saat operasi Penskalaan dalam status Menunggu.
properties.maxSizeBytes		integer (int64)	Ukuran maksimum database yang dinyatakan dalam byte.
properties.minCapacity		number (double)	Kapasitas minimal yang akan selalu dialokasikan database, jika tidak dijeda
properties.performCutover		boolean	Untuk memicu cutover manual yang dikontrol pelanggan selama status tunggu saat operasi Penskalaan sedang berlangsung. Parameter properti ini hanya berlaku untuk operasi penskalaan yang dimulai bersama dengan parameter 'manualCutover'. Properti ini hanya berlaku saat penskalaan database dari tingkat Business Critical/General Purpose/Premium/Standard ke tingkat Hyperscale sudah berlangsung. Ketika performCutover ditentukan, operasi penskalaan akan memicu cutover dan melakukan perubahan peran ke database Hyperscale.
properties.preferredEnclaveType		AlwaysEncryptedEnclaveType	Jenis enklave yang diminta pada database yaitu enklave Default atau VBS.
properties.readScale		DatabaseReadScale	Status perutean baca-saja. Jika diaktifkan, koneksi yang memiliki niat aplikasi diatur ke readonly dalam string koneksinya dapat dirutekan ke replika sekunder baca-saja di wilayah yang sama. Tidak berlaku untuk database Hyperscale dalam kumpulan elastis.
properties.recoverableDatabaseId		string (arm-id)	Pengidentifikasi sumber daya database yang dapat dipulihkan yang terkait dengan operasi pembuatan database ini.
properties.recoveryServicesRecoveryPointId		string (arm-id)	Pengidentifikasi sumber daya titik pemulihan yang terkait dengan operasi pembuatan database ini.
properties.requestedBackupStorageRedundancy		BackupStorageRedundancy	Jenis akun penyimpanan yang akan digunakan untuk menyimpan cadangan untuk database ini.
properties.restorableDroppedDatabaseId		string (arm-id)	Pengidentifikasi sumber daya dari database yang dihilangkan yang dapat dihilangkan yang terkait dengan operasi pembuatan database ini.
properties.restorePointInTime		string (date-time)	Menentukan titik waktu (format ISO8601) database sumber yang akan dipulihkan untuk membuat database baru.
properties.sampleName		SampleName	Nama skema sampel yang akan diterapkan saat membuat database ini.
properties.secondaryType		SecondaryType	Jenis database sekunder jika merupakan sekunder. Nilai yang valid adalah Geo, Bernama, dan Siaga.
properties.sourceDatabaseDeletionDate		string (date-time)	Menentukan waktu database dihapus.
properties.sourceDatabaseId		string (arm-id)	Pengidentifikasi sumber daya database sumber yang terkait dengan operasi pembuatan database ini.
properties.sourceResourceId		string (arm-id)	Pengidentifikasi sumber daya sumber yang terkait dengan operasi pembuatan database ini. Properti ini hanya didukung untuk edisi DataWarehouse dan memungkinkan pemulihan di seluruh langganan. Ketika sourceResourceId ditentukan, sourceDatabaseId, recoverableDatabaseId, restorableDroppedDatabaseId dan sourceDatabaseDeletionDate tidak boleh ditentukan dan CreateMode harus PointInTimeRestore, Restore atau Recover. Ketika createMode adalah PointInTimeRestore, sourceResourceId harus menjadi ID sumber daya database yang ada atau kumpulan sql yang ada, dan restorePointInTime harus ditentukan. Ketika createMode adalah Restore, sourceResourceId harus menjadi ID sumber daya database yang dihilangkan yang dapat dipulihkan atau kumpulan sql yang dapat dihilangkan kembali. Ketika createMode adalah Recover, sourceResourceId harus menjadi ID sumber daya database yang dapat dipulihkan atau kumpulan sql yang dapat dipulihkan. Saat langganan sumber milik penyewa yang berbeda dari langganan target, header "x-ms-authorization-auxiliary" harus berisi token autentikasi untuk penyewa sumber. Untuk detail selengkapnya tentang header "x-ms-authorization-auxiliary" lihat https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/authenticate-multi-tenant
properties.useFreeLimit		boolean	Apakah database menggunakan batas bulanan gratis atau tidak. Diizinkan pada satu database dalam langganan.
properties.zoneRedundant		boolean	Apakah database ini redundan zona atau tidak, yang berarti replika database ini akan tersebar di beberapa zona ketersediaan.
sku		Sku	SKU database. Daftar SKU dapat bervariasi menurut wilayah dan penawaran dukungan. Untuk menentukan SKU (termasuk nama SKU, tingkat/edisi, keluarga, dan kapasitas) yang tersedia untuk langganan Anda di wilayah Azure, gunakan `Capabilities_ListByLocation` REST API atau salah satu perintah berikut: `az sql db list-editions -l <location> -o table` `Get-AzSqlServerServiceObjective -Location <location>`
tags		object	Tag sumber daya.

Respons

Nama	Jenis	Deskripsi
200 OK	Database	Operasi pembaruan 'Database' sumber daya berhasil
201 Created	Database	Operasi pembuatan 'Database' sumber daya berhasil Header Azure-AsyncOperation: string
202 Accepted		Operasi sumber daya diterima. Header Location: string Retry-After: integer
Other Status Codes	ErrorResponse	Respons kesalahan yang tidak terduga.

Keamanan

azure_auth

Alur OAuth2 Azure Active Directory.

Jenis: oauth2
Alur: implicit
URL Otorisasi: https://login.microsoftonline.com/common/oauth2/authorize

Cakupan

Nama	Deskripsi
user_impersonation	meniru akun pengguna Anda

Contoh

Creates a data warehouse database as a cross-subscription restore from a backup of a dropped database.

Creates a data warehouse database as a cross-subscription restore from a geo-backup.

Creates a data warehouse database as a cross-subscription restore from a restore point of an existing database.

Creates a database as a copy.

Creates a database as a standby secondary.

Creates a database as an on-line secondary.

Creates a database as named replica secondary.

Creates a database from PointInTimeRestore.

Creates a database with availability zone specified.

Creates a database with database-level customer managed keys.

Creates a database with database-level versionless customer managed keys.

Creates a database with Default enclave type.

Creates a database with default mode.

Creates a database with encryption protector auto rotation.

Creates a database with ledger on.

Creates a database with minimum number of parameters.

Creates a database with preferred maintenance window.

Creates a database with specified backup storage redundancy.

Creates a database with VBS enclave type.

Creates a VCore database by specifying service objective name.

Creates a VCore database by specifying sku name and capacity.

Updates a database to Hyperscale SLO with manual cutover

Updates a database to Hyperscale tier by triggering manual cutover during Migration workflow

Creates a data warehouse database as a cross-subscription restore from a backup of a dropped database.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdw?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "createMode": "Restore",
    "sourceResourceId": "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/restorableDroppedDatabases/srcdw,131403269876900000"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionRestore.json
     */
    /**
     * Sample code: Creates a data warehouse database as a cross-subscription restore from a backup of a dropped
     * database.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromABackupOfADroppedDatabase(
        com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdw",
            new DatabaseInner().withLocation("southeastasia").withCreateMode(CreateMode.RESTORE).withSourceResourceId(
                "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/restorableDroppedDatabases/srcdw,131403269876900000"),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_dw_database_cross_subscription_restore.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdw",
        parameters={
            "location": "southeastasia",
            "properties": {
                "createMode": "Restore",
                "sourceResourceId": "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/restorableDroppedDatabases/srcdw,131403269876900000",
            },
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionRestore.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionRestore.json
 */
async function createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromABackupOfADroppedDatabase() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdw",
    {
      location: "southeastasia",
      createMode: "Restore",
      sourceResourceId:
        "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/restorableDroppedDatabases/srcdw,131403269876900000",
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDwDatabaseCrossSubscriptionRestore.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdw";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    CreateMode = SqlDatabaseCreateMode.Restore,
    SourceResourceId = new ResourceIdentifier("/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/restorableDroppedDatabases/srcdw,131403269876900000"),
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdw",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdw",
  "kind": "v12.0,user,datawarehouse,gen2",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-01-24T06:46:14.99Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "DW1000c",
    "currentSku": {
      "name": "DataWarehouse",
      "capacity": 9000,
      "tier": "DataWarehouse"
    },
    "databaseId": "188784c9-d602-4684-86cf-e67b6f03551a",
    "defaultSecondaryLocation": "eastus",
    "maxSizeBytes": 263882790666240,
    "readScale": "Disabled",
    "requestedServiceObjectiveName": "DW1000c",
    "status": "Online"
  },
  "sku": {
    "name": "DataWarehouse",
    "capacity": 9000,
    "tier": "DataWarehouse"
  }
}

Kode status:: 201

{
  "name": "testdw",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdw",
  "kind": "v12.0,user,datawarehouse,gen2",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-01-24T06:46:14.99Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "DW1000c",
    "currentSku": {
      "name": "DataWarehouse",
      "capacity": 9000,
      "tier": "DataWarehouse"
    },
    "databaseId": "188784c9-d602-4684-86cf-e67b6f03551a",
    "defaultSecondaryLocation": "eastus",
    "maxSizeBytes": 263882790666240,
    "readScale": "Disabled",
    "requestedServiceObjectiveName": "DW1000c",
    "status": "Online"
  },
  "sku": {
    "name": "DataWarehouse",
    "capacity": 9000,
    "tier": "DataWarehouse"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a data warehouse database as a cross-subscription restore from a geo-backup.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-WestUS/providers/Microsoft.Sql/servers/testsvr/databases/testdw?api-version=2025-01-01

{
  "location": "westus",
  "properties": {
    "createMode": "Recovery",
    "sourceResourceId": "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-EastUS/providers/Microsoft.Sql/servers/srcsvr/recoverabledatabases/srcdw"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionRecovery.json
     */
    /**
     * Sample code: Creates a data warehouse database as a cross-subscription restore from a geo-backup.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromAGeoBackup(
        com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-WestUS", "testsvr", "testdw",
            new DatabaseInner().withLocation("westus").withCreateMode(CreateMode.RECOVERY).withSourceResourceId(
                "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-EastUS/providers/Microsoft.Sql/servers/srcsvr/recoverabledatabases/srcdw"),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_dw_database_cross_subscription_recovery.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-WestUS",
        server_name="testsvr",
        database_name="testdw",
        parameters={
            "location": "westus",
            "properties": {
                "createMode": "Recovery",
                "sourceResourceId": "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-EastUS/providers/Microsoft.Sql/servers/srcsvr/recoverabledatabases/srcdw",
            },
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionRecovery.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionRecovery.json
 */
async function createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromAGeoBackup() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate("Default-SQL-WestUS", "testsvr", "testdw", {
    location: "westus",
    createMode: "Recovery",
    sourceResourceId:
      "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-EastUS/providers/Microsoft.Sql/servers/srcsvr/recoverabledatabases/srcdw",
  });
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDwDatabaseCrossSubscriptionRecovery.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-WestUS";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdw";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("westus"))
{
    CreateMode = SqlDatabaseCreateMode.Recovery,
    SourceResourceId = new ResourceIdentifier("/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-EastUS/providers/Microsoft.Sql/servers/srcsvr/recoverabledatabases/srcdw"),
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdw",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-WestUS/providers/Microsoft.Sql/servers/testsvr/databases/testdw",
  "kind": "v12.0,user,datawarehouse,gen2",
  "location": "westus",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-01-24T06:46:14.99Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "DW1000c",
    "currentSku": {
      "name": "DataWarehouse",
      "capacity": 9000,
      "tier": "DataWarehouse"
    },
    "databaseId": "188784c9-d602-4684-86cf-e67b6f03551a",
    "defaultSecondaryLocation": "eastus",
    "maxSizeBytes": 263882790666240,
    "readScale": "Disabled",
    "requestedServiceObjectiveName": "DW1000c",
    "status": "Online"
  },
  "sku": {
    "name": "DataWarehouse",
    "capacity": 9000,
    "tier": "DataWarehouse"
  }
}

Kode status:: 201

{
  "name": "testdw",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-WestUS/providers/Microsoft.Sql/servers/testsvr/databases/testdw",
  "kind": "v12.0,user,datawarehouse,gen2",
  "location": "westus",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-01-24T06:46:14.99Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "DW1000c",
    "currentSku": {
      "name": "DataWarehouse",
      "capacity": 9000,
      "tier": "DataWarehouse"
    },
    "databaseId": "188784c9-d602-4684-86cf-e67b6f03551a",
    "defaultSecondaryLocation": "eastus",
    "maxSizeBytes": 263882790666240,
    "readScale": "Disabled",
    "requestedServiceObjectiveName": "DW1000c",
    "status": "Online"
  },
  "sku": {
    "name": "DataWarehouse",
    "capacity": 9000,
    "tier": "DataWarehouse"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a data warehouse database as a cross-subscription restore from a restore point of an existing database.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdw?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "createMode": "PointInTimeRestore",
    "restorePointInTime": "2022-01-22T05:35:31.503Z",
    "sourceResourceId": "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/databases/srcdw"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import java.time.OffsetDateTime;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionPITR.json
     */
    /**
     * Sample code: Creates a data warehouse database as a cross-subscription restore from a restore point of an
     * existing database.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromARestorePointOfAnExistingDatabase(
        com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdw",
            new DatabaseInner().withLocation("southeastasia").withCreateMode(CreateMode.POINT_IN_TIME_RESTORE)
                .withRestorePointInTime(OffsetDateTime.parse("2022-01-22T05:35:31.503Z")).withSourceResourceId(
                    "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/databases/srcdw"),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_dw_database_cross_subscription_pitr.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdw",
        parameters={
            "location": "southeastasia",
            "properties": {
                "createMode": "PointInTimeRestore",
                "restorePointInTime": "2022-01-22T05:35:31.503Z",
                "sourceResourceId": "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/databases/srcdw",
            },
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionPITR.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDwDatabaseCrossSubscriptionPITR.json
 */
async function createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromARestorePointOfAnExistingDatabase() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdw",
    {
      location: "southeastasia",
      createMode: "PointInTimeRestore",
      restorePointInTime: new Date("2022-01-22T05:35:31.503Z"),
      sourceResourceId:
        "/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/databases/srcdw",
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDwDatabaseCrossSubscriptionPITR.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdw";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    CreateMode = SqlDatabaseCreateMode.PointInTimeRestore,
    RestorePointInTime = DateTimeOffset.Parse("2022-01-22T05:35:31.503Z"),
    SourceResourceId = new ResourceIdentifier("/subscriptions/55555555-6666-7777-8888-999999999999/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/srcsvr/databases/srcdw"),
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdw",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdw",
  "kind": "v12.0,user,datawarehouse,gen2",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-01-24T06:46:14.99Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "DW1000c",
    "currentSku": {
      "name": "DataWarehouse",
      "capacity": 9000,
      "tier": "DataWarehouse"
    },
    "databaseId": "188784c9-d602-4684-86cf-e67b6f03551a",
    "defaultSecondaryLocation": "eastus",
    "maxSizeBytes": 263882790666240,
    "readScale": "Disabled",
    "requestedServiceObjectiveName": "DW1000c",
    "status": "Online"
  },
  "sku": {
    "name": "DataWarehouse",
    "capacity": 9000,
    "tier": "DataWarehouse"
  }
}

Kode status:: 201

{
  "name": "testdw",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdw",
  "kind": "v12.0,user,datawarehouse,gen2",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-01-24T06:46:14.99Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "DW1000c",
    "currentSku": {
      "name": "DataWarehouse",
      "capacity": 9000,
      "tier": "DataWarehouse"
    },
    "databaseId": "188784c9-d602-4684-86cf-e67b6f03551a",
    "defaultSecondaryLocation": "eastus",
    "maxSizeBytes": 263882790666240,
    "readScale": "Disabled",
    "requestedServiceObjectiveName": "DW1000c",
    "status": "Online"
  },
  "sku": {
    "name": "DataWarehouse",
    "capacity": 9000,
    "tier": "DataWarehouse"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database as a copy.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/dbcopy?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "createMode": "Copy",
    "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb"
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseCopyMode.json
     */
    /**
     * Sample code: Creates a database as a copy.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseAsACopy(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "dbcopy",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withCreateMode(CreateMode.COPY).withSourceDatabaseId(
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb"),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_copy_mode.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="dbcopy",
        parameters={
            "location": "southeastasia",
            "properties": {
                "createMode": "Copy",
                "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseCopyMode.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseCopyMode.json
 */
async function createsADatabaseAsACopy() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "dbcopy",
    {
      location: "southeastasia",
      createMode: "Copy",
      sourceDatabaseId:
        "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseCopyMode.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "dbcopy";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    CreateMode = SqlDatabaseCreateMode.Copy,
    SourceDatabaseId = new ResourceIdentifier("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb"),
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "dbcopy",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/dbcopy",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "dbcopy",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/dbcopy",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database as a standby secondary.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "createMode": "Secondary",
    "secondaryType": "Standby",
    "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb"
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.SecondaryType;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseStandbyMode.json
     */
    /**
     * Sample code: Creates a database as a standby secondary.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseAsAStandbySecondary(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withCreateMode(CreateMode.SECONDARY)
                .withSourceDatabaseId(
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb")
                .withSecondaryType(SecondaryType.STANDBY),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_standby_mode.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "location": "southeastasia",
            "properties": {
                "createMode": "Secondary",
                "secondaryType": "Standby",
                "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb",
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseStandbyMode.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseStandbyMode.json
 */
async function createsADatabaseAsAStandbySecondary() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      location: "southeastasia",
      createMode: "Secondary",
      secondaryType: "Standby",
      sourceDatabaseId:
        "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb",
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseStandbyMode.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    CreateMode = SqlDatabaseCreateMode.Secondary,
    SourceDatabaseId = new ResourceIdentifier("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb"),
    SecondaryType = SecondaryType.Standby,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "secondaryType": "Standby",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "secondaryType": "Standby",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Creates a database as an on-line secondary.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "createMode": "Secondary",
    "secondaryType": "Geo",
    "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb"
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.SecondaryType;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseSecondaryMode.json
     */
    /**
     * Sample code: Creates a database as an on-line secondary.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseAsAnOnLineSecondary(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withCreateMode(CreateMode.SECONDARY)
                .withSourceDatabaseId(
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb")
                .withSecondaryType(SecondaryType.GEO),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_secondary_mode.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "location": "southeastasia",
            "properties": {
                "createMode": "Secondary",
                "secondaryType": "Geo",
                "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb",
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseSecondaryMode.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseSecondaryMode.json
 */
async function createsADatabaseAsAnOnLineSecondary() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      location: "southeastasia",
      createMode: "Secondary",
      secondaryType: "Geo",
      sourceDatabaseId:
        "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb",
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseSecondaryMode.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    CreateMode = SqlDatabaseCreateMode.Secondary,
    SourceDatabaseId = new ResourceIdentifier("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/testdb"),
    SecondaryType = SecondaryType.Geo,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "secondaryType": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "secondaryType": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database as named replica secondary.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "createMode": "Secondary",
    "secondaryType": "Named",
    "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/primarydb"
  },
  "sku": {
    "name": "HS_Gen4",
    "capacity": 2,
    "tier": "Hyperscale"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.SecondaryType;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseNamedReplica.json
     */
    /**
     * Sample code: Creates a database as named replica secondary.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseAsNamedReplicaSecondary(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia")
                .withSku(new Sku().withName("HS_Gen4").withTier("Hyperscale").withCapacity(2))
                .withCreateMode(CreateMode.SECONDARY)
                .withSourceDatabaseId(
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/primarydb")
                .withSecondaryType(SecondaryType.NAMED),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_named_replica.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "location": "southeastasia",
            "properties": {
                "createMode": "Secondary",
                "secondaryType": "Named",
                "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/primarydb",
            },
            "sku": {"capacity": 2, "name": "HS_Gen4", "tier": "Hyperscale"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseNamedReplica.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseNamedReplica.json
 */
async function createsADatabaseAsNamedReplicaSecondary() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      location: "southeastasia",
      createMode: "Secondary",
      secondaryType: "Named",
      sourceDatabaseId:
        "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/primarydb",
      sku: { name: "HS_Gen4", capacity: 2, tier: "Hyperscale" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseNamedReplica.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("HS_Gen4")
    {
        Tier = "Hyperscale",
        Capacity = 2,
    },
    CreateMode = SqlDatabaseCreateMode.Secondary,
    SourceDatabaseId = new ResourceIdentifier("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-NorthEurope/providers/Microsoft.Sql/servers/testsvr1/databases/primarydb"),
    SecondaryType = SecondaryType.Named,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user,vcore,hyperscale",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "HS_Gen4_2",
    "currentSku": {
      "name": "HS_Gen4",
      "capacity": 2,
      "family": "Gen4",
      "tier": "Hyperscale"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "highAvailabilityReplicaCount": 0,
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maxSizeBytes": -1,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "HS_Gen4_2",
    "secondaryType": "Named",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "HS_Gen4",
    "capacity": 2,
    "family": "Gen4",
    "tier": "Hyperscale"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user,vcore,hyperscale",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "HS_Gen4_2",
    "currentSku": {
      "name": "HS_Gen4",
      "capacity": 2,
      "family": "Gen4",
      "tier": "Hyperscale"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "highAvailabilityReplicaCount": 0,
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maxSizeBytes": -1,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "HS_Gen4_2",
    "secondaryType": "Named",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "HS_Gen4",
    "capacity": 2,
    "family": "Gen4",
    "tier": "Hyperscale"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database from PointInTimeRestore.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/dbpitr?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "createMode": "PointInTimeRestore",
    "restorePointInTime": "2020-10-22T05:35:31.503Z",
    "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SoutheastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import java.time.OffsetDateTime;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabasePITRMode.json
     */
    /**
     * Sample code: Creates a database from PointInTimeRestore.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseFromPointInTimeRestore(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "dbpitr",
            new DatabaseInner().withLocation("southeastasia").withCreateMode(CreateMode.POINT_IN_TIME_RESTORE)
                .withSourceDatabaseId(
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SoutheastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb")
                .withRestorePointInTime(OffsetDateTime.parse("2020-10-22T05:35:31.503Z")),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_pitr_mode.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="dbpitr",
        parameters={
            "location": "southeastasia",
            "properties": {
                "createMode": "PointInTimeRestore",
                "restorePointInTime": "2020-10-22T05:35:31.503Z",
                "sourceDatabaseId": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SoutheastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
            },
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabasePITRMode.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabasePITRMode.json
 */
async function createsADatabaseFromPointInTimeRestore() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "dbpitr",
    {
      location: "southeastasia",
      createMode: "PointInTimeRestore",
      restorePointInTime: new Date("2020-10-22T05:35:31.503Z"),
      sourceDatabaseId:
        "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SoutheastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabasePITRMode.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "dbpitr";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    CreateMode = SqlDatabaseCreateMode.PointInTimeRestore,
    SourceDatabaseId = new ResourceIdentifier("/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SoutheastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb"),
    RestorePointInTime = DateTimeOffset.Parse("2020-10-22T05:35:31.503Z"),
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "dbpitr",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SoutheastAsia/providers/Microsoft.Sql/servers/testsvr/databases/dbpitr",
  "kind": "v12.0,user",
  "location": "SoutheastAsia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2020-10-23T20:31:35.807Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "2463ef48-53e2-4c26-9781-2d7138080bfd",
    "defaultSecondaryLocation": "SoutheastAsia",
    "earliestRestoreDate": "2020-10-23T20:47:37Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "dbpitr",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SoutheastAsia/providers/Microsoft.Sql/servers/testsvr/databases/dbpitr",
  "kind": "v12.0,user",
  "location": "SoutheastAsia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2020-10-23T20:31:35.807Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "2463ef48-53e2-4c26-9781-2d7138080bfd",
    "defaultSecondaryLocation": "SoutheastAsia",
    "earliestRestoreDate": "2020-10-23T20:47:37Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with availability zone specified.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "availabilityZone": "1",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "createMode": "Default",
    "maxSizeBytes": 1073741824
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.AvailabilityZoneType;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseWithAvailabilityZone.json
     */
    /**
     * Sample code: Creates a database with availability zone specified.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsADatabaseWithAvailabilityZoneSpecified(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withCreateMode(CreateMode.DEFAULT).withCollation("SQL_Latin1_General_CP1_CI_AS")
                .withMaxSizeBytes(1073741824L).withAvailabilityZone(AvailabilityZoneType.ONE),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_with_availability_zone.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "location": "southeastasia",
            "properties": {
                "availabilityZone": "1",
                "collation": "SQL_Latin1_General_CP1_CI_AS",
                "createMode": "Default",
                "maxSizeBytes": 1073741824,
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseWithAvailabilityZone.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseWithAvailabilityZone.json
 */
async function createsADatabaseWithAvailabilityZoneSpecified() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      location: "southeastasia",
      availabilityZone: "1",
      collation: "SQL_Latin1_General_CP1_CI_AS",
      createMode: "Default",
      maxSizeBytes: 1073741824,
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseWithAvailabilityZone.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    CreateMode = SqlDatabaseCreateMode.Default,
    Collation = "SQL_Latin1_General_CP1_CI_AS",
    MaxSizeBytes = 1073741824L,
    AvailabilityZone = SqlAvailabilityZoneType.One,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "availabilityZone": "1",
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "availabilityZone": "1",
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Creates a database with database-level customer managed keys.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi": {}
    }
  },
  "location": "southeastasia",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "createMode": "Default",
    "encryptionProtector": "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
    "keys": {
      "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion": {},
      "https://your-key-vault-name.vault.azure.net/yourKey2/yourKey2Version": {}
    },
    "maxSizeBytes": 1073741824
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.DatabaseIdentity;
import com.azure.resourcemanager.sql.models.DatabaseIdentityType;
import com.azure.resourcemanager.sql.models.DatabaseKey;
import com.azure.resourcemanager.sql.models.DatabaseUserIdentity;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultModeWithKeysAndEncryptionProtector.json
     */
    /**
     * Sample code: Creates a database with database-level customer managed keys.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsADatabaseWithDatabaseLevelCustomerManagedKeys(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withIdentity(new DatabaseIdentity().withType(DatabaseIdentityType.USER_ASSIGNED)
                    .withUserAssignedIdentities(mapOf(
                        "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi",
                        new DatabaseUserIdentity())))
                .withCreateMode(CreateMode.DEFAULT).withCollation("SQL_Latin1_General_CP1_CI_AS")
                .withMaxSizeBytes(1073741824L)
                .withKeys(mapOf("https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion", new DatabaseKey(),
                    "https://your-key-vault-name.vault.azure.net/yourKey2/yourKey2Version", new DatabaseKey()))
                .withEncryptionProtector("https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion"),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_default_mode_with_keys_and_encryption_protector.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "identity": {
                "type": "UserAssigned",
                "userAssignedIdentities": {
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi": {}
                },
            },
            "location": "southeastasia",
            "properties": {
                "collation": "SQL_Latin1_General_CP1_CI_AS",
                "createMode": "Default",
                "encryptionProtector": "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
                "keys": {
                    "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion": {},
                    "https://your-key-vault-name.vault.azure.net/yourKey2/yourKey2Version": {},
                },
                "maxSizeBytes": 1073741824,
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseDefaultModeWithKeysAndEncryptionProtector.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultModeWithKeysAndEncryptionProtector.json
 */
async function createsADatabaseWithDatabaseLevelCustomerManagedKeys() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      identity: {
        type: "UserAssigned",
        userAssignedIdentities: {
          "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi":
            {},
        },
      },
      location: "southeastasia",
      collation: "SQL_Latin1_General_CP1_CI_AS",
      createMode: "Default",
      encryptionProtector: "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
      keys: {
        "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion": {},
        "https://your-key-vault-name.vault.azure.net/yourKey2/yourKey2Version": {},
      },
      maxSizeBytes: 1073741824,
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseDefaultModeWithKeysAndEncryptionProtector.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    Identity = new DatabaseIdentity
    {
        IdentityType = DatabaseIdentityType.UserAssigned,
        UserAssignedIdentities =
        {
        ["/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi"] = new UserAssignedIdentity()
        },
    },
    CreateMode = SqlDatabaseCreateMode.Default,
    Collation = "SQL_Latin1_General_CP1_CI_AS",
    MaxSizeBytes = 1073741824L,
    Keys =
    {
    ["https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion"] = new SqlDatabaseKey(),
    ["https://your-key-vault-name.vault.azure.net/yourKey2/yourKey2Version"] = new SqlDatabaseKey()
    },
    EncryptionProtector = "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with database-level versionless customer managed keys.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi": {}
    }
  },
  "location": "southeastasia",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "createMode": "Default",
    "encryptionProtector": "https://your-key-vault-name.vault.azure.net/yourKey",
    "keys": {
      "https://your-key-vault-name.vault.azure.net/yourKey": {},
      "https://your-key-vault-name.vault.azure.net/yourKey2": {}
    },
    "maxSizeBytes": 1073741824
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.DatabaseIdentity;
import com.azure.resourcemanager.sql.models.DatabaseIdentityType;
import com.azure.resourcemanager.sql.models.DatabaseKey;
import com.azure.resourcemanager.sql.models.DatabaseUserIdentity;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultModeWithVersionlessKeysAndVersionlessEncryptionProtector.json
     */
    /**
     * Sample code: Creates a database with database-level versionless customer managed keys.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseWithDatabaseLevelVersionlessCustomerManagedKeys(
        com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withIdentity(new DatabaseIdentity().withType(DatabaseIdentityType.USER_ASSIGNED)
                    .withUserAssignedIdentities(mapOf(
                        "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi",
                        new DatabaseUserIdentity())))
                .withCreateMode(CreateMode.DEFAULT).withCollation("SQL_Latin1_General_CP1_CI_AS")
                .withMaxSizeBytes(1073741824L)
                .withKeys(mapOf("https://your-key-vault-name.vault.azure.net/yourKey", new DatabaseKey(),
                    "https://your-key-vault-name.vault.azure.net/yourKey2", new DatabaseKey()))
                .withEncryptionProtector("https://your-key-vault-name.vault.azure.net/yourKey"),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_default_mode_with_versionless_keys_and_versionless_encryption_protector.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "identity": {
                "type": "UserAssigned",
                "userAssignedIdentities": {
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi": {}
                },
            },
            "location": "southeastasia",
            "properties": {
                "collation": "SQL_Latin1_General_CP1_CI_AS",
                "createMode": "Default",
                "encryptionProtector": "https://your-key-vault-name.vault.azure.net/yourKey",
                "keys": {
                    "https://your-key-vault-name.vault.azure.net/yourKey": {},
                    "https://your-key-vault-name.vault.azure.net/yourKey2": {},
                },
                "maxSizeBytes": 1073741824,
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseDefaultModeWithVersionlessKeysAndVersionlessEncryptionProtector.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultModeWithVersionlessKeysAndVersionlessEncryptionProtector.json
 */
async function createsADatabaseWithDatabaseLevelVersionlessCustomerManagedKeys() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      identity: {
        type: "UserAssigned",
        userAssignedIdentities: {
          "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi":
            {},
        },
      },
      location: "southeastasia",
      collation: "SQL_Latin1_General_CP1_CI_AS",
      createMode: "Default",
      encryptionProtector: "https://your-key-vault-name.vault.azure.net/yourKey",
      keys: {
        "https://your-key-vault-name.vault.azure.net/yourKey": {},
        "https://your-key-vault-name.vault.azure.net/yourKey2": {},
      },
      maxSizeBytes: 1073741824,
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseDefaultModeWithVersionlessKeysAndVersionlessEncryptionProtector.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    Identity = new DatabaseIdentity
    {
        IdentityType = DatabaseIdentityType.UserAssigned,
        UserAssignedIdentities =
        {
        ["/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi"] = new UserAssignedIdentity()
        },
    },
    CreateMode = SqlDatabaseCreateMode.Default,
    Collation = "SQL_Latin1_General_CP1_CI_AS",
    MaxSizeBytes = 1073741824L,
    Keys =
    {
    ["https://your-key-vault-name.vault.azure.net/yourKey"] = new SqlDatabaseKey(),
    ["https://your-key-vault-name.vault.azure.net/yourKey2"] = new SqlDatabaseKey()
    },
    EncryptionProtector = "https://your-key-vault-name.vault.azure.net/yourKey",
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with Default enclave type.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "preferredEnclaveType": "Default"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.AlwaysEncryptedEnclaveType;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultEnclave.json
     */
    /**
     * Sample code: Creates a database with Default enclave type.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseWithDefaultEnclaveType(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases()
            .createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb", new DatabaseInner()
                .withLocation("southeastasia").withPreferredEnclaveType(AlwaysEncryptedEnclaveType.DEFAULT),
                com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_default_enclave.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={"location": "southeastasia", "properties": {"preferredEnclaveType": "Default"}},
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseDefaultEnclave.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultEnclave.json
 */
async function createsADatabaseWithDefaultEnclaveType() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    { location: "southeastasia", preferredEnclaveType: "Default" },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseDefaultEnclave.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    PreferredEnclaveType = SqlAlwaysEncryptedEnclaveType.Default,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "maxSizeBytes": 268435456000,
    "preferredEnclaveType": "Default",
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Zone",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "maxSizeBytes": 268435456000,
    "preferredEnclaveType": "Default",
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Zone",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with default mode.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "createMode": "Default",
    "maxSizeBytes": 1073741824
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultMode.json
     */
    /**
     * Sample code: Creates a database with default mode.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseWithDefaultMode(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withCreateMode(CreateMode.DEFAULT).withCollation("SQL_Latin1_General_CP1_CI_AS")
                .withMaxSizeBytes(1073741824L),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_default_mode.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "location": "southeastasia",
            "properties": {
                "collation": "SQL_Latin1_General_CP1_CI_AS",
                "createMode": "Default",
                "maxSizeBytes": 1073741824,
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseDefaultMode.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseDefaultMode.json
 */
async function createsADatabaseWithDefaultMode() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      location: "southeastasia",
      collation: "SQL_Latin1_General_CP1_CI_AS",
      createMode: "Default",
      maxSizeBytes: 1073741824,
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseDefaultMode.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    CreateMode = SqlDatabaseCreateMode.Default,
    Collation = "SQL_Latin1_General_CP1_CI_AS",
    MaxSizeBytes = 1073741824L,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with encryption protector auto rotation.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi": {}
    }
  },
  "location": "southeastasia",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "createMode": "Default",
    "encryptionProtector": "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
    "encryptionProtectorAutoRotation": true,
    "maxSizeBytes": 1073741824
  },
  "sku": {
    "name": "S0",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.DatabaseIdentity;
import com.azure.resourcemanager.sql.models.DatabaseIdentityType;
import com.azure.resourcemanager.sql.models.DatabaseUserIdentity;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseWithEncryptionProtectorAutoRotation.json
     */
    /**
     * Sample code: Creates a database with encryption protector auto rotation.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsADatabaseWithEncryptionProtectorAutoRotation(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S0").withTier("Standard"))
                .withIdentity(new DatabaseIdentity().withType(DatabaseIdentityType.USER_ASSIGNED)
                    .withUserAssignedIdentities(mapOf(
                        "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi",
                        new DatabaseUserIdentity())))
                .withCreateMode(CreateMode.DEFAULT).withCollation("SQL_Latin1_General_CP1_CI_AS")
                .withMaxSizeBytes(1073741824L)
                .withEncryptionProtector("https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion")
                .withEncryptionProtectorAutoRotation(true),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_with_encryption_protector_auto_rotation.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "identity": {
                "type": "UserAssigned",
                "userAssignedIdentities": {
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi": {}
                },
            },
            "location": "southeastasia",
            "properties": {
                "collation": "SQL_Latin1_General_CP1_CI_AS",
                "createMode": "Default",
                "encryptionProtector": "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
                "encryptionProtectorAutoRotation": True,
                "maxSizeBytes": 1073741824,
            },
            "sku": {"name": "S0", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseWithEncryptionProtectorAutoRotation.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseWithEncryptionProtectorAutoRotation.json
 */
async function createsADatabaseWithEncryptionProtectorAutoRotation() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      identity: {
        type: "UserAssigned",
        userAssignedIdentities: {
          "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi":
            {},
        },
      },
      location: "southeastasia",
      collation: "SQL_Latin1_General_CP1_CI_AS",
      createMode: "Default",
      encryptionProtector: "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
      encryptionProtectorAutoRotation: true,
      maxSizeBytes: 1073741824,
      sku: { name: "S0", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseWithEncryptionProtectorAutoRotation.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S0")
    {
        Tier = "Standard",
    },
    Identity = new DatabaseIdentity
    {
        IdentityType = DatabaseIdentityType.UserAssigned,
        UserAssignedIdentities =
        {
        ["/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.ManagedIdentity/userAssignedIdentities/umi"] = new UserAssignedIdentity()
        },
    },
    CreateMode = SqlDatabaseCreateMode.Default,
    Collation = "SQL_Latin1_General_CP1_CI_AS",
    MaxSizeBytes = 1073741824L,
    EncryptionProtector = "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
    EncryptionProtectorAutoRotation = true,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "encryptionProtector": "https://your-key-vault-name.vault.azure.net/yourKey/yourKeyVersion",
    "encryptionProtectorAutoRotation": true,
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S0",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with ledger on.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "isLedgerOn": true
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseLedger.json
     */
    /**
     * Sample code: Creates a database with ledger on.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseWithLedgerOn(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withIsLedgerOn(true), com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_ledger.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={"location": "southeastasia", "properties": {"isLedgerOn": True}},
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseLedger.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseLedger.json
 */
async function createsADatabaseWithLedgerOn() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    { location: "southeastasia", isLedgerOn: true },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseLedger.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    IsLedgerOn = true,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isLedgerOn": true,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Zone",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Zone",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with minimum number of parameters.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia"
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseMin.json
     */
    /**
     * Sample code: Creates a database with minimum number of parameters.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsADatabaseWithMinimumNumberOfParameters(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia"), com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_min.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={"location": "southeastasia"},
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseMin.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseMin.json
 */
async function createsADatabaseWithMinimumNumberOfParameters() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    { location: "southeastasia" },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseMin.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"));
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with preferred maintenance window.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "createMode": "Default",
    "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_SouthEastAsia_1",
    "maxSizeBytes": 1073741824
  },
  "sku": {
    "name": "S2",
    "tier": "Standard"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.CreateMode;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseMaintenanceConfiguration.json
     */
    /**
     * Sample code: Creates a database with preferred maintenance window.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsADatabaseWithPreferredMaintenanceWindow(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("S2").withTier("Standard"))
                .withCreateMode(CreateMode.DEFAULT).withCollation("SQL_Latin1_General_CP1_CI_AS")
                .withMaxSizeBytes(1073741824L).withMaintenanceConfigurationId(
                    "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_SouthEastAsia_1"),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_maintenance_configuration.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "location": "southeastasia",
            "properties": {
                "collation": "SQL_Latin1_General_CP1_CI_AS",
                "createMode": "Default",
                "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_SouthEastAsia_1",
                "maxSizeBytes": 1073741824,
            },
            "sku": {"name": "S2", "tier": "Standard"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseMaintenanceConfiguration.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseMaintenanceConfiguration.json
 */
async function createsADatabaseWithPreferredMaintenanceWindow() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      location: "southeastasia",
      collation: "SQL_Latin1_General_CP1_CI_AS",
      createMode: "Default",
      maintenanceConfigurationId:
        "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_SouthEastAsia_1",
      maxSizeBytes: 1073741824,
      sku: { name: "S2", tier: "Standard" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseMaintenanceConfiguration.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("S2")
    {
        Tier = "Standard",
    },
    CreateMode = SqlDatabaseCreateMode.Default,
    Collation = "SQL_Latin1_General_CP1_CI_AS",
    MaxSizeBytes = 1073741824L,
    MaintenanceConfigurationId = new ResourceIdentifier("/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_SouthEastAsia_1"),
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S2",
    "currentSku": {
      "name": "Standard",
      "capacity": 50,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2020-08-29T06:41:18.283Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_SouthEastAsia_1",
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S2",
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S2",
    "currentSku": {
      "name": "Standard",
      "capacity": 50,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2020-08-29T06:41:18.283Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_SouthEastAsia_1",
    "maxSizeBytes": 1073741824,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "S2",
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with specified backup storage redundancy.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "requestedBackupStorageRedundancy": "Zone"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.BackupStorageRedundancy;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseConfiguredBackupStorageRedundancy.json
     */
    /**
     * Sample code: Creates a database with specified backup storage redundancy.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsADatabaseWithSpecifiedBackupStorageRedundancy(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases()
            .createOrUpdate(
                "Default-SQL-SouthEastAsia", "testsvr", "testdb", new DatabaseInner().withLocation("southeastasia")
                    .withRequestedBackupStorageRedundancy(BackupStorageRedundancy.ZONE),
                com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_configured_backup_storage_redundancy.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={"location": "southeastasia", "properties": {"requestedBackupStorageRedundancy": "Zone"}},
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseConfiguredBackupStorageRedundancy.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseConfiguredBackupStorageRedundancy.json
 */
async function createsADatabaseWithSpecifiedBackupStorageRedundancy() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    { location: "southeastasia", requestedBackupStorageRedundancy: "Zone" },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseConfiguredBackupStorageRedundancy.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    RequestedBackupStorageRedundancy = SqlBackupStorageRedundancy.Zone,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Zone",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Zone",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Zone",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "maxSizeBytes": 268435456000,
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Zone",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a database with VBS enclave type.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "properties": {
    "preferredEnclaveType": "VBS"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.AlwaysEncryptedEnclaveType;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateDatabaseVBSEnclave.json
     */
    /**
     * Sample code: Creates a database with VBS enclave type.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void createsADatabaseWithVBSEnclaveType(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withPreferredEnclaveType(AlwaysEncryptedEnclaveType.VBS),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_database_vbs_enclave.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={"location": "southeastasia", "properties": {"preferredEnclaveType": "VBS"}},
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateDatabaseVBSEnclave.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateDatabaseVBSEnclave.json
 */
async function createsADatabaseWithVBSEnclaveType() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    { location: "southeastasia", preferredEnclaveType: "VBS" },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateDatabaseVBSEnclave.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    PreferredEnclaveType = SqlAlwaysEncryptedEnclaveType.Vbs,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "maxSizeBytes": 268435456000,
    "preferredEnclaveType": "VBS",
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Zone",
    "currentServiceObjectiveName": "S0",
    "currentSku": {
      "name": "Standard",
      "capacity": 10,
      "tier": "Standard"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "maxSizeBytes": 268435456000,
    "preferredEnclaveType": "VBS",
    "readScale": "Disabled",
    "requestedBackupStorageRedundancy": "Zone",
    "requestedServiceObjectiveName": "S0",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "Standard",
    "capacity": 10,
    "tier": "Standard"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a VCore database by specifying service objective name.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "sku": {
    "name": "BC",
    "capacity": 2,
    "family": "Gen4"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateVCoreDatabaseByServiceObjective.json
     */
    /**
     * Sample code: Creates a VCore database by specifying service objective name.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsAVCoreDatabaseBySpecifyingServiceObjectiveName(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases()
            .createOrUpdate(
                "Default-SQL-SouthEastAsia", "testsvr", "testdb", new DatabaseInner().withLocation("southeastasia")
                    .withSku(new Sku().withName("BC").withFamily("Gen4").withCapacity(2)),
                com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_vcore_database_by_service_objective.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={"location": "southeastasia", "sku": {"capacity": 2, "family": "Gen4", "name": "BC"}},
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateVCoreDatabaseByServiceObjective.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateVCoreDatabaseByServiceObjective.json
 */
async function createsAVCoreDatabaseBySpecifyingServiceObjectiveName() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    { location: "southeastasia", sku: { name: "BC", capacity: 2, family: "Gen4" } },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateVCoreDatabaseByServiceObjective.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("BC")
    {
        Family = "Gen4",
        Capacity = 2,
    },
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "BC_Gen4_2",
    "currentSku": {
      "name": "BC_Gen4",
      "capacity": 2,
      "tier": "BusinessCritical"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maxLogSizeBytes": 104857600,
    "maxSizeBytes": 1073741824,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "BC_Gen4",
    "capacity": 2,
    "family": "Gen4",
    "tier": "BusinessCritical"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "BC_Gen4_2",
    "currentSku": {
      "name": "BC_Gen4",
      "capacity": 2,
      "tier": "BusinessCritical"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maxLogSizeBytes": 104857600,
    "maxSizeBytes": 1073741824,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "BC_Gen4",
    "capacity": 2,
    "family": "Gen4",
    "tier": "BusinessCritical"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Creates a VCore database by specifying sku name and capacity.

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "location": "southeastasia",
  "sku": {
    "name": "BC_Gen4",
    "capacity": 2
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/CreateVCoreDatabaseBySkuNameCapacity.json
     */
    /**
     * Sample code: Creates a VCore database by specifying sku name and capacity.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        createsAVCoreDatabaseBySpecifyingSkuNameAndCapacity(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withSku(new Sku().withName("BC_Gen4").withCapacity(2)),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python create_vcore_database_by_sku_name_capacity.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={"location": "southeastasia", "sku": {"capacity": 2, "name": "BC_Gen4"}},
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/CreateVCoreDatabaseBySkuNameCapacity.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/CreateVCoreDatabaseBySkuNameCapacity.json
 */
async function createsAVCoreDatabaseBySpecifyingSkuNameAndCapacity() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    { location: "southeastasia", sku: { name: "BC_Gen4", capacity: 2 } },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/CreateVCoreDatabaseBySkuNameCapacity.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("BC_Gen4")
    {
        Capacity = 2,
    },
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "BC_Gen4_2",
    "currentSku": {
      "name": "BC_Gen4",
      "capacity": 2,
      "tier": "BusinessCritical"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maxLogSizeBytes": 104857600,
    "maxSizeBytes": 1073741824,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "BC_Gen4",
    "capacity": 2,
    "family": "Gen4",
    "tier": "BusinessCritical"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "BC_Gen4_2",
    "currentSku": {
      "name": "BC_Gen4",
      "capacity": 2,
      "tier": "BusinessCritical"
    },
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2017-06-07T04:51:33.937Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maxLogSizeBytes": 104857600,
    "maxSizeBytes": 1073741824,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "BC_Gen4",
    "capacity": 2,
    "family": "Gen4",
    "tier": "BusinessCritical"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Updates a database to Hyperscale SLO with manual cutover

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi": {},
      "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete": null
    }
  },
  "location": "southeastasia",
  "properties": {
    "manualCutover": true
  },
  "sku": {
    "name": "HS_Gen5_2",
    "tier": "Hyperscale"
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.DatabaseIdentity;
import com.azure.resourcemanager.sql.models.DatabaseIdentityType;
import com.azure.resourcemanager.sql.models.DatabaseUserIdentity;
import com.azure.resourcemanager.sql.models.Sku;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/UpdateDatabaseHyperscaleMigrationWithManualCutover.json
     */
    /**
     * Sample code: Updates a database to Hyperscale SLO with manual cutover.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void
        updatesADatabaseToHyperscaleSLOWithManualCutover(com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia")
                .withSku(new Sku().withName("HS_Gen5_2").withTier("Hyperscale"))
                .withIdentity(new DatabaseIdentity().withType(DatabaseIdentityType.USER_ASSIGNED)
                    .withUserAssignedIdentities(mapOf(
                        "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi",
                        new DatabaseUserIdentity(),
                        "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete",
                        null)))
                .withManualCutover(true),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python update_database_hyperscale_migration_with_manual_cutover.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "identity": {
                "type": "UserAssigned",
                "userAssignedIdentities": {
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi": {},
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete": None,
                },
            },
            "location": "southeastasia",
            "properties": {"manualCutover": True},
            "sku": {"name": "HS_Gen5_2", "tier": "Hyperscale"},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/UpdateDatabaseHyperscaleMigrationWithManualCutover.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/UpdateDatabaseHyperscaleMigrationWithManualCutover.json
 */
async function updatesADatabaseToHyperscaleSLOWithManualCutover() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      identity: {
        type: "UserAssigned",
        userAssignedIdentities: {
          "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi":
            {},
        },
      },
      location: "southeastasia",
      manualCutover: true,
      sku: { name: "HS_Gen5_2", tier: "Hyperscale" },
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/UpdateDatabaseHyperscaleMigrationWithManualCutover.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Sku = new SqlSku("HS_Gen5_2")
    {
        Tier = "Hyperscale",
    },
    Identity = new DatabaseIdentity
    {
        IdentityType = DatabaseIdentityType.UserAssigned,
        UserAssignedIdentities =
        {
        ["/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi"] = new UserAssignedIdentity(),
        ["/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete"] = default
        },
    },
    ManualCutover = true,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user,vcore",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-12-08T12:41:23.953Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "GP_Gen5_2",
    "currentSku": {
      "name": "GP_Gen5",
      "capacity": 2,
      "family": "Gen5",
      "tier": "GeneralPurpose"
    },
    "databaseId": "dad50ee1-9fbb-4fb9-bd2b-5786d175ce3c",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2022-12-08T12:42:00Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
    "maxLogSizeBytes": 193273528320,
    "maxSizeBytes": 34359738368,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "HS_Gen5_2",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "HS_Gen5",
    "capacity": 2,
    "family": "Gen5",
    "tier": "Hyperscale"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user,vcore",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-12-08T12:41:23.953Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "GP_Gen5_2",
    "currentSku": {
      "name": "GP_Gen5",
      "capacity": 2,
      "family": "Gen5",
      "tier": "GeneralPurpose"
    },
    "databaseId": "dad50ee1-9fbb-4fb9-bd2b-5786d175ce3c",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2022-12-08T12:42:00Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
    "maxLogSizeBytes": 193273528320,
    "maxSizeBytes": 34359738368,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "HS_Gen5_2",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "HS_Gen5",
    "capacity": 2,
    "family": "Gen5",
    "tier": "Hyperscale"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Updates a database to Hyperscale tier by triggering manual cutover during Migration workflow

Permintaan sampel

PUT https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb?api-version=2025-01-01

{
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi": {},
      "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete": null
    }
  },
  "location": "southeastasia",
  "properties": {
    "performCutover": true
  }
}


import com.azure.resourcemanager.sql.fluent.models.DatabaseInner;
import com.azure.resourcemanager.sql.models.DatabaseIdentity;
import com.azure.resourcemanager.sql.models.DatabaseIdentityType;
import com.azure.resourcemanager.sql.models.DatabaseUserIdentity;
import java.util.HashMap;
import java.util.Map;

/**
 * Samples for Databases CreateOrUpdate.
 */
public final class Main {
    /*
     * x-ms-original-file: 2025-01-01/UpdateDatabaseHyperscaleMigrationPerformCutover.json
     */
    /**
     * Sample code: Updates a database to Hyperscale tier by triggering manual cutover during Migration workflow.
     * 
     * @param manager Entry point to SqlServerManager.
     */
    public static void updatesADatabaseToHyperscaleTierByTriggeringManualCutoverDuringMigrationWorkflow(
        com.azure.resourcemanager.sql.SqlServerManager manager) {
        manager.serviceClient().getDatabases().createOrUpdate("Default-SQL-SouthEastAsia", "testsvr", "testdb",
            new DatabaseInner().withLocation("southeastasia").withIdentity(new DatabaseIdentity()
                .withType(DatabaseIdentityType.USER_ASSIGNED)
                .withUserAssignedIdentities(mapOf(
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi",
                    new DatabaseUserIdentity(),
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete",
                    null)))
                .withPerformCutover(true),
            com.azure.core.util.Context.NONE);
    }

    // Use "Map.of" if available
    @SuppressWarnings("unchecked")
    private static <T> Map<String, T> mapOf(Object... inputs) {
        Map<String, T> map = new HashMap<>();
        for (int i = 0; i < inputs.length; i += 2) {
            String key = (String) inputs[i];
            T value = (T) inputs[i + 1];
            map.put(key, value);
        }
        return map;
    }
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

from azure.identity import DefaultAzureCredential

from azure.mgmt.sql import SqlManagementClient

"""
# PREREQUISITES
    pip install azure-identity
    pip install azure-mgmt-sql
# USAGE
    python update_database_hyperscale_migration_perform_cutover.py

    Before run the sample, please set the values of the client ID, tenant ID and client secret
    of the AAD application as environment variables: AZURE_CLIENT_ID, AZURE_TENANT_ID,
    AZURE_CLIENT_SECRET. For more info about how to get the value, please see:
    https://docs.microsoft.com/azure/active-directory/develop/howto-create-service-principal-portal
"""


def main():
    client = SqlManagementClient(
        credential=DefaultAzureCredential(),
        subscription_id="SUBSCRIPTION_ID",
    )

    response = client.databases.begin_create_or_update(
        resource_group_name="Default-SQL-SouthEastAsia",
        server_name="testsvr",
        database_name="testdb",
        parameters={
            "identity": {
                "type": "UserAssigned",
                "userAssignedIdentities": {
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi": {},
                    "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete": None,
                },
            },
            "location": "southeastasia",
            "properties": {"performCutover": True},
        },
    ).result()
    print(response)


# x-ms-original-file: 2025-01-01/UpdateDatabaseHyperscaleMigrationPerformCutover.json
if __name__ == "__main__":
    main()

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

const { SqlManagementClient } = require("@azure/arm-sql");
const { DefaultAzureCredential } = require("@azure/identity");

/**
 * This sample demonstrates how to creates a new database or updates an existing database.
 *
 * @summary creates a new database or updates an existing database.
 * x-ms-original-file: 2025-01-01/UpdateDatabaseHyperscaleMigrationPerformCutover.json
 */
async function updatesADatabaseToHyperscaleTierByTriggeringManualCutoverDuringMigrationWorkflow() {
  const credential = new DefaultAzureCredential();
  const subscriptionId = "00000000-1111-2222-3333-444444444444";
  const client = new SqlManagementClient(credential, subscriptionId);
  const result = await client.databases.createOrUpdate(
    "Default-SQL-SouthEastAsia",
    "testsvr",
    "testdb",
    {
      identity: {
        type: "UserAssigned",
        userAssignedIdentities: {
          "/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi":
            {},
        },
      },
      location: "southeastasia",
      performCutover: true,
    },
  );
  console.log(result);
}

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Models;
using Azure.ResourceManager.Sql.Models;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/SQL/stable/2025-01-01/examples/UpdateDatabaseHyperscaleMigrationPerformCutover.json
// this example is just showing the usage of "Databases_CreateOrUpdate" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this SqlServerResource created on azure
// for more information of creating SqlServerResource, please refer to the document of SqlServerResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "Default-SQL-SouthEastAsia";
string serverName = "testsvr";
ResourceIdentifier sqlServerResourceId = SqlServerResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, serverName);
SqlServerResource sqlServer = client.GetSqlServerResource(sqlServerResourceId);

// get the collection of this SqlDatabaseResource
SqlDatabaseCollection collection = sqlServer.GetSqlDatabases();

// invoke the operation
string databaseName = "testdb";
SqlDatabaseData data = new SqlDatabaseData(new AzureLocation("southeastasia"))
{
    Identity = new DatabaseIdentity
    {
        IdentityType = DatabaseIdentityType.UserAssigned,
        UserAssignedIdentities =
        {
        ["/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umi"] = new UserAssignedIdentity(),
        ["/subscriptions/00000000-1111-2222-3333-444444444444/resourcegroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/userAssignedIdentities/umiToDelete"] = default
        },
    },
    PerformCutover = true,
};
ArmOperation<SqlDatabaseResource> lro = await collection.CreateOrUpdateAsync(WaitUntil.Completed, databaseName, data);
SqlDatabaseResource result = lro.Value;

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
SqlDatabaseData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

Respon sampel

Kode status:: 200

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user,vcore",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-12-08T12:41:23.953Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "GP_Gen5_2",
    "currentSku": {
      "name": "GP_Gen5",
      "capacity": 2,
      "family": "Gen5",
      "tier": "GeneralPurpose"
    },
    "databaseId": "dad50ee1-9fbb-4fb9-bd2b-5786d175ce3c",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2022-12-08T12:42:00Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
    "maxLogSizeBytes": 193273528320,
    "maxSizeBytes": 34359738368,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "HS_Gen5_2",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "HS_Gen5",
    "capacity": 2,
    "family": "Gen5",
    "tier": "Hyperscale"
  }
}

Kode status:: 201

{
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "kind": "v12.0,user,vcore",
  "location": "southeastasia",
  "properties": {
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS",
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "creationDate": "2022-12-08T12:41:23.953Z",
    "currentBackupStorageRedundancy": "Geo",
    "currentServiceObjectiveName": "GP_Gen5_2",
    "currentSku": {
      "name": "GP_Gen5",
      "capacity": 2,
      "family": "Gen5",
      "tier": "GeneralPurpose"
    },
    "databaseId": "dad50ee1-9fbb-4fb9-bd2b-5786d175ce3c",
    "defaultSecondaryLocation": "North Europe",
    "earliestRestoreDate": "2022-12-08T12:42:00Z",
    "isInfraEncryptionEnabled": false,
    "isLedgerOn": false,
    "licenseType": "LicenseIncluded",
    "maintenanceConfigurationId": "/subscriptions/00000000-1111-2222-3333-444444444444/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default",
    "maxLogSizeBytes": 193273528320,
    "maxSizeBytes": 34359738368,
    "readScale": "Enabled",
    "requestedBackupStorageRedundancy": "Geo",
    "requestedServiceObjectiveName": "HS_Gen5_2",
    "status": "Online",
    "zoneRedundant": false
  },
  "sku": {
    "name": "HS_Gen5",
    "capacity": 2,
    "family": "Gen5",
    "tier": "Hyperscale"
  }
}

Kode status:: 202

Location: /subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/locations/southeastasia/databaseOperationResults/11111111-1111-1111-1111-111111111111

Definisi

Nama	Deskripsi
AlwaysEncryptedEnclaveType	Jenis enklave yang diminta pada database yaitu enklave Default atau VBS.
AvailabilityZoneType	Menentukan zona ketersediaan tempat database disematkan.
BackupStorageRedundancy	Jenis akun penyimpanan yang digunakan untuk menyimpan cadangan untuk database ini.
CatalogCollationType	Kolate katalog metadata.
createdByType	Jenis identitas yang membuat sumber daya tersebut.
CreateMode	Menentukan mode pembuatan database. Default: pembuatan database reguler. Salin: membuat database sebagai salinan database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database sumber. Sekunder: membuat database sebagai replika sekunder dari database yang ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya dari database utama yang ada. PointInTimeRestore: Membuat database dengan memulihkan cadangan titik waktu database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang ada, dan restorePointInTime harus ditentukan. Pemulihan: Membuat database dengan memulihkan cadangan yang direplikasi secara geografis. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang dapat dipulihkan untuk dipulihkan. Pemulihan: Membuat database dengan memulihkan cadangan database yang dihapus. sourceDatabaseId harus ditentukan. Jika sourceDatabaseId adalah ID sumber daya asli database, maka sourceDatabaseDeletionDate harus ditentukan. Jika tidak, sourceDatabaseId harus menjadi ID sumber daya database yang dihilangkan dan sourceDatabaseDeletionDate yang dapat diabaikan. restorePointInTime juga dapat ditentukan untuk memulihkan dari titik waktu sebelumnya. RestoreLongTermRetentionBackup: Membuat database dengan memulihkan dari vault retensi jangka panjang. recoveryServicesRecoveryPointResourceId harus ditentukan sebagai ID sumber daya titik pemulihan. Copy, Secondary, dan RestoreLongTermRetentionBackup tidak didukung untuk edisi DataWarehouse.
Database	Sumber daya database.
DatabaseIdentity	Konfigurasi identitas Azure Active Directory untuk sumber daya.
DatabaseIdentityType	Jenis identitas
DatabaseKey	Kunci tingkat database yang digunakan untuk enkripsi saat tidak aktif.
DatabaseKeyType	Jenis kunci database. Hanya nilai yang didukung adalah 'AzureKeyVault'.
DatabaseLicenseType	Jenis lisensi yang akan diterapkan untuk database ini. `LicenseIncluded` jika Anda memerlukan lisensi, atau `BasePrice` jika Anda memiliki lisensi dan memenuhi syarat untuk Azure Hybrid Benefit.
DatabaseReadScale	Status perutean baca-saja. Jika diaktifkan, koneksi yang memiliki niat aplikasi diatur ke readonly dalam string koneksinya dapat dirutekan ke replika sekunder baca-saja di wilayah yang sama. Tidak berlaku untuk database Hyperscale dalam kumpulan elastis.
DatabaseStatus	Status database.
DatabaseUserIdentity	Konfigurasi identitas Azure Active Directory untuk sumber daya.
ErrorAdditionalInfo	Info tambahan kesalahan manajemen sumber daya.
ErrorDetail	Detail kesalahan.
ErrorResponse	Tanggapan kesalahan
FreeLimitExhaustionBehavior	Menentukan perilaku ketika batas gratis bulanan habis untuk database gratis. Jeda Otomatis: Database akan dijeda secara otomatis setelah kelelahan batas gratis selama sisa bulan. BillForUsage: Database akan terus online setelah kelelahan batas gratis dan kelebihan biaya apa pun akan ditagih.
SampleName	Nama skema sampel yang akan diterapkan saat membuat database ini.
SecondaryType	Jenis database sekunder jika merupakan sekunder. Nilai yang valid adalah Geo, Bernama, dan Siaga.
Sku	Definisi model sumber daya yang mewakili SKU
SkuTier	Bidang ini diperlukan untuk diimplementasikan oleh Penyedia Sumber Jika layanan memiliki lebih dari satu tingkat, tetapi tidak diperlukan pada PUT.
systemData	Metadata yang berkaitan dengan pembuatan dan modifikasi terakhir sumber daya.

AlwaysEncryptedEnclaveType

Enumerasi

Jenis enklave yang diminta pada database yaitu enklave Default atau VBS.

Nilai	Deskripsi
Default	Default
VBS	VBS

AvailabilityZoneType

Enumerasi

Menentukan zona ketersediaan tempat database disematkan.

Nilai	Deskripsi
NoPreference	Tidak Ada Preferensi
1	1
2	2
3	3

BackupStorageRedundancy

Enumerasi

Jenis akun penyimpanan yang digunakan untuk menyimpan cadangan untuk database ini.

Nilai	Deskripsi
Geo	Geo
Local	Local
Zone	Zone
GeoZone	GeoZone

CatalogCollationType

Enumerasi

Kolate katalog metadata.

Nilai	Deskripsi
DATABASE_DEFAULT	DATABASE_DEFAULT
SQL_Latin1_General_CP1_CI_AS	SQL_Latin1_General_CP1_CI_AS

createdByType

Enumerasi

Jenis identitas yang membuat sumber daya tersebut.

Nilai	Deskripsi
User
Application
ManagedIdentity
Key

CreateMode

Enumerasi

Menentukan mode pembuatan database.

Default: pembuatan database reguler.

Salin: membuat database sebagai salinan database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database sumber.

Sekunder: membuat database sebagai replika sekunder dari database yang ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya dari database utama yang ada.

PointInTimeRestore: Membuat database dengan memulihkan cadangan titik waktu database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang ada, dan restorePointInTime harus ditentukan.

Pemulihan: Membuat database dengan memulihkan cadangan yang direplikasi secara geografis. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang dapat dipulihkan untuk dipulihkan.

Pemulihan: Membuat database dengan memulihkan cadangan database yang dihapus. sourceDatabaseId harus ditentukan. Jika sourceDatabaseId adalah ID sumber daya asli database, maka sourceDatabaseDeletionDate harus ditentukan. Jika tidak, sourceDatabaseId harus menjadi ID sumber daya database yang dihilangkan dan sourceDatabaseDeletionDate yang dapat diabaikan. restorePointInTime juga dapat ditentukan untuk memulihkan dari titik waktu sebelumnya.

RestoreLongTermRetentionBackup: Membuat database dengan memulihkan dari vault retensi jangka panjang. recoveryServicesRecoveryPointResourceId harus ditentukan sebagai ID sumber daya titik pemulihan.

Copy, Secondary, dan RestoreLongTermRetentionBackup tidak didukung untuk edisi DataWarehouse.

Nilai	Deskripsi
Default	Default
Copy	Copy
Secondary	Secondary
PointInTimeRestore	PointInTimeRestore
Restore	Restore
Recovery	Recovery
RestoreExternalBackup	PulihkanEksternalCadangan
RestoreExternalBackupSecondary	RestoreExternalBackupSecondary
RestoreLongTermRetentionBackup	Pulihkan Cadangan Retensi Jangka Panjang
OnlineSecondary	OnlineSekunder

Database

Objek

Sumber daya database.

Nama	Jenis	Deskripsi
id	string (arm-id)	ID sumber daya lengkap untuk sumber daya tersebut. Misalnya "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
identity	DatabaseIdentity	Identitas Azure Active Directory database.
kind	string	Jenis database. Ini adalah metadata yang digunakan untuk pengalaman portal Microsoft Azure.
location	string	Lokasi geografis tempat sumber daya berada
managedBy	string	Sumber daya yang mengelola database.
name	string	Nama sumber daya.
properties.autoPauseDelay	integer (int32)	Waktu dalam menit setelah database dijeda secara otomatis. Nilai -1 berarti jeda otomatis dinonaktifkan
properties.availabilityZone	AvailabilityZoneType	Menentukan zona ketersediaan tempat database disematkan.
properties.catalogCollation	CatalogCollationType	Kolate katalog metadata.
properties.collation	string	Kolatasi database.
properties.createMode	CreateMode	Menentukan mode pembuatan database. Default: pembuatan database reguler. Salin: membuat database sebagai salinan database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database sumber. Sekunder: membuat database sebagai replika sekunder dari database yang ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya dari database utama yang ada. PointInTimeRestore: Membuat database dengan memulihkan cadangan titik waktu database yang sudah ada. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang ada, dan restorePointInTime harus ditentukan. Pemulihan: Membuat database dengan memulihkan cadangan yang direplikasi secara geografis. sourceDatabaseId harus ditentukan sebagai ID sumber daya database yang dapat dipulihkan untuk dipulihkan. Pemulihan: Membuat database dengan memulihkan cadangan database yang dihapus. sourceDatabaseId harus ditentukan. Jika sourceDatabaseId adalah ID sumber daya asli database, maka sourceDatabaseDeletionDate harus ditentukan. Jika tidak, sourceDatabaseId harus menjadi ID sumber daya database yang dihilangkan dan sourceDatabaseDeletionDate yang dapat diabaikan. restorePointInTime juga dapat ditentukan untuk memulihkan dari titik waktu sebelumnya. RestoreLongTermRetentionBackup: Membuat database dengan memulihkan dari vault retensi jangka panjang. recoveryServicesRecoveryPointResourceId harus ditentukan sebagai ID sumber daya titik pemulihan. Copy, Secondary, dan RestoreLongTermRetentionBackup tidak didukung untuk edisi DataWarehouse.
properties.creationDate	string (date-time)	Tanggal pembuatan database (format ISO8601).
properties.currentBackupStorageRedundancy	BackupStorageRedundancy	Jenis akun penyimpanan yang digunakan untuk menyimpan cadangan untuk database ini.
properties.currentServiceObjectiveName	string	Nama tujuan tingkat layanan database saat ini.
properties.currentSku	Sku	Nama dan tingkat SKU.
properties.databaseId	string (uuid)	ID database.
properties.defaultSecondaryLocation	string	Wilayah sekunder default untuk database ini.
properties.earliestRestoreDate	string (date-time)	Ini mencatat tanggal dan waktu mulai paling awal yang pemulihan tersedia untuk database ini (format ISO8601).
properties.elasticPoolId	string (arm-id)	Pengidentifikasi sumber daya kumpulan elastis yang berisi database ini.
properties.encryptionProtector	string	URI brankas kunci azure database jika dikonfigurasi dengan per Kunci Terkelola Pelanggan Database.
properties.encryptionProtectorAutoRotation	boolean	Bendera untuk mengaktifkan atau menonaktifkan rotasi otomatis kunci AKV pelindung enkripsi database.
properties.failoverGroupId	string	Pengidentifikasi sumber daya Grup Failover tempat database ini berada.
properties.federatedClientId	string (uuid)	Id Klien yang digunakan untuk skenario CMK lintas penyewa per database
properties.freeLimitExhaustionBehavior	FreeLimitExhaustionBehavior	Menentukan perilaku ketika batas gratis bulanan habis untuk database gratis. Jeda Otomatis: Database akan dijeda secara otomatis setelah kelelahan batas gratis selama sisa bulan. BillForUsage: Database akan terus online setelah kelelahan batas gratis dan kelebihan biaya apa pun akan ditagih.
properties.highAvailabilityReplicaCount	integer (int32)	Jumlah replika sekunder yang terkait dengan database edisi Business Critical, Premium, atau Hyperscale yang digunakan untuk memberikan ketersediaan tinggi. Tidak berlaku untuk database Hyperscale dalam kumpulan elastis.
properties.isInfraEncryptionEnabled	boolean	Enkripsi Infra diaktifkan untuk database ini.
properties.isLedgerOn	boolean	Apakah database ini adalah database ledger atau tidak, yang berarti semua tabel dalam database adalah tabel ledger. Catatan: nilai properti ini tidak dapat diubah setelah database dibuat.
properties.keys	<string, DatabaseKey>	Id sumber daya dari identitas yang ditetapkan pengguna untuk digunakan
properties.licenseType	DatabaseLicenseType	Jenis lisensi yang akan diterapkan untuk database ini. `LicenseIncluded` jika Anda memerlukan lisensi, atau `BasePrice` jika Anda memiliki lisensi dan memenuhi syarat untuk Azure Hybrid Benefit.
properties.longTermRetentionBackupResourceId	string (arm-id)	Pengidentifikasi sumber daya cadangan retensi jangka panjang yang terkait dengan operasi pembuatan database ini.
properties.maintenanceConfigurationId	string	Id konfigurasi pemeliharaan yang ditetapkan ke database. Konfigurasi ini menentukan periode kapan pembaruan pemeliharaan akan terjadi.
properties.manualCutover	boolean	Apakah cutover manual yang dikontrol pelanggan perlu dilakukan selama operasi Pembaruan Database ke tingkat Hyperscale atau tidak. Properti ini hanya berlaku saat menskalakan database dari tingkat Business Critical/General Purpose/Premium/Standard ke tingkat Hyperscale. Ketika manualCutover ditentukan, operasi penskalaan akan menunggu input pengguna untuk memicu cutover ke database Hyperscale. Untuk memicu cutover, harap berikan parameter 'performCutover' saat operasi Penskalaan dalam status Menunggu.
properties.maxLogSizeBytes	integer (int64)	Ukuran log maks untuk database ini.
properties.maxSizeBytes	integer (int64)	Ukuran maksimum database yang dinyatakan dalam byte.
properties.minCapacity	number (double)	Kapasitas minimal yang akan selalu dialokasikan database, jika tidak dijeda
properties.pausedDate	string (date-time)	Tanggal saat database dijeda oleh konfigurasi atau tindakan pengguna(format ISO8601). Null jika database sudah siap.
properties.performCutover	boolean	Untuk memicu cutover manual yang dikontrol pelanggan selama status tunggu saat operasi Penskalaan sedang berlangsung. Parameter properti ini hanya berlaku untuk operasi penskalaan yang dimulai bersama dengan parameter 'manualCutover'. Properti ini hanya berlaku saat penskalaan database dari tingkat Business Critical/General Purpose/Premium/Standard ke tingkat Hyperscale sudah berlangsung. Ketika performCutover ditentukan, operasi penskalaan akan memicu cutover dan melakukan perubahan peran ke database Hyperscale.
properties.preferredEnclaveType	AlwaysEncryptedEnclaveType	Jenis enklave yang diminta pada database yaitu enklave Default atau VBS.
properties.readScale	DatabaseReadScale	Status perutean baca-saja. Jika diaktifkan, koneksi yang memiliki niat aplikasi diatur ke readonly dalam string koneksinya dapat dirutekan ke replika sekunder baca-saja di wilayah yang sama. Tidak berlaku untuk database Hyperscale dalam kumpulan elastis.
properties.recoverableDatabaseId	string (arm-id)	Pengidentifikasi sumber daya database yang dapat dipulihkan yang terkait dengan operasi pembuatan database ini.
properties.recoveryServicesRecoveryPointId	string (arm-id)	Pengidentifikasi sumber daya titik pemulihan yang terkait dengan operasi pembuatan database ini.
properties.requestedBackupStorageRedundancy	BackupStorageRedundancy	Jenis akun penyimpanan yang akan digunakan untuk menyimpan cadangan untuk database ini.
properties.requestedServiceObjectiveName	string	Nama tujuan tingkat layanan yang diminta dari database.
properties.restorableDroppedDatabaseId	string (arm-id)	Pengidentifikasi sumber daya dari database yang dihilangkan yang dapat dihilangkan yang terkait dengan operasi pembuatan database ini.
properties.restorePointInTime	string (date-time)	Menentukan titik waktu (format ISO8601) database sumber yang akan dipulihkan untuk membuat database baru.
properties.resumedDate	string (date-time)	Tanggal ketika database dilanjutkan oleh tindakan pengguna atau login database (format ISO8601). Null jika database dijeda.
properties.sampleName	SampleName	Nama skema sampel yang akan diterapkan saat membuat database ini.
properties.secondaryType	SecondaryType	Jenis database sekunder jika merupakan sekunder. Nilai yang valid adalah Geo, Bernama, dan Siaga.
properties.sourceDatabaseDeletionDate	string (date-time)	Menentukan waktu database dihapus.
properties.sourceDatabaseId	string (arm-id)	Pengidentifikasi sumber daya database sumber yang terkait dengan operasi pembuatan database ini.
properties.sourceResourceId	string (arm-id)	Pengidentifikasi sumber daya sumber yang terkait dengan operasi pembuatan database ini. Properti ini hanya didukung untuk edisi DataWarehouse dan memungkinkan pemulihan di seluruh langganan. Ketika sourceResourceId ditentukan, sourceDatabaseId, recoverableDatabaseId, restorableDroppedDatabaseId dan sourceDatabaseDeletionDate tidak boleh ditentukan dan CreateMode harus PointInTimeRestore, Restore atau Recover. Ketika createMode adalah PointInTimeRestore, sourceResourceId harus menjadi ID sumber daya database yang ada atau kumpulan sql yang ada, dan restorePointInTime harus ditentukan. Ketika createMode adalah Restore, sourceResourceId harus menjadi ID sumber daya database yang dihilangkan yang dapat dipulihkan atau kumpulan sql yang dapat dihilangkan kembali. Ketika createMode adalah Recover, sourceResourceId harus menjadi ID sumber daya database yang dapat dipulihkan atau kumpulan sql yang dapat dipulihkan. Saat langganan sumber milik penyewa yang berbeda dari langganan target, header "x-ms-authorization-auxiliary" harus berisi token autentikasi untuk penyewa sumber. Untuk detail selengkapnya tentang header "x-ms-authorization-auxiliary" lihat https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/authenticate-multi-tenant
properties.status	DatabaseStatus	Status database.
properties.useFreeLimit	boolean	Apakah database menggunakan batas bulanan gratis atau tidak. Diizinkan pada satu database dalam langganan.
properties.zoneRedundant	boolean	Apakah database ini redundan zona atau tidak, yang berarti replika database ini akan tersebar di beberapa zona ketersediaan.
sku	Sku	SKU database. Daftar SKU dapat bervariasi menurut wilayah dan penawaran dukungan. Untuk menentukan SKU (termasuk nama SKU, tingkat/edisi, keluarga, dan kapasitas) yang tersedia untuk langganan Anda di wilayah Azure, gunakan `Capabilities_ListByLocation` REST API atau salah satu perintah berikut: `az sql db list-editions -l <location> -o table` `Get-AzSqlServerServiceObjective -Location <location>`
systemData	systemData	Metadata Azure Resource Manager yang berisi informasi createBy dan modifiedBy.
tags	object	Tag sumber daya.
type	string	Jenis sumber daya. Misalnya, "Microsoft.Compute/virtualMachines" atau "Microsoft.Storage/storageAccounts"

DatabaseIdentity

Objek

Konfigurasi identitas Azure Active Directory untuk sumber daya.

Nama	Jenis	Deskripsi
tenantId	string (uuid)	Id penyewa Azure Active Directory.
type	DatabaseIdentityType	Jenis identitas
userAssignedIdentities	<string, DatabaseUserIdentity>	Id sumber daya dari identitas yang ditetapkan pengguna untuk digunakan

DatabaseIdentityType

Enumerasi

Jenis identitas

Nilai	Deskripsi
None	None
UserAssigned	UserAssigned

DatabaseKey

Objek

Kunci tingkat database yang digunakan untuk enkripsi saat tidak aktif.

Nama	Jenis	Deskripsi
creationDate	string (date-time)	Tanggal pembuatan kunci database.
keyVersion	string	Versi kunci database.
subregion	string	Subregion kunci server.
thumbprint	string	Thumbprint kunci database.
type	DatabaseKeyType	Jenis kunci database. Hanya nilai yang didukung adalah 'AzureKeyVault'.

DatabaseKeyType

Enumerasi

Jenis kunci database. Hanya nilai yang didukung adalah 'AzureKeyVault'.

Nilai	Deskripsi
AzureKeyVault	AzureKeyVault

DatabaseLicenseType

Enumerasi

Jenis lisensi yang akan diterapkan untuk database ini. LicenseIncluded jika Anda memerlukan lisensi, atau BasePrice jika Anda memiliki lisensi dan memenuhi syarat untuk Azure Hybrid Benefit.

Nilai	Deskripsi
LicenseIncluded	Termasuk Lisensi
BasePrice	BasePrice

DatabaseReadScale

Enumerasi

Status perutean baca-saja. Jika diaktifkan, koneksi yang memiliki niat aplikasi diatur ke readonly dalam string koneksinya dapat dirutekan ke replika sekunder baca-saja di wilayah yang sama. Tidak berlaku untuk database Hyperscale dalam kumpulan elastis.

Nilai	Deskripsi
Enabled	Enabled
Disabled	Disabled

DatabaseStatus

Enumerasi

Status database.

Nilai	Deskripsi
Online	Online
Restoring	Memulihkan
RecoveryPending	PemulihanTertunda
Recovering	Memulihkan
Suspect	Mencurigai
Offline	Offline
Standby	Siaga
Shutdown	Shutdown
EmergencyMode	Mode Darurat
AutoClosed	Tertutup Otomatis
Copying	Menyalin
Creating	Membuat
Inaccessible	Tidak dapat diakses
OfflineSecondary	OfflineSekunder
Pausing	Menjeda
Paused	Dijeda
Resuming	Melanjutkan
Scaling	Scaling
OfflineChangingDwPerformanceTiers	OfflineChangingDwPerformanceTiers
OnlineChangingDwPerformanceTiers	OnlineChangingDwPerformanceTiers
Disabled	Disabled
Stopping	Berhenti
Stopped	Dihentikan
Starting	Mulai

DatabaseUserIdentity

Objek

Konfigurasi identitas Azure Active Directory untuk sumber daya.

Nama	Jenis	Deskripsi
clientId	string (uuid)	Id klien Azure Active Directory.
principalId	string (uuid)	Id utama Azure Active Directory.

ErrorAdditionalInfo

Objek

Info tambahan kesalahan manajemen sumber daya.

Nama	Jenis	Deskripsi
info	object	Info tambahan.
type	string	Jenis info tambahan.

ErrorDetail

Objek

Detail kesalahan.

Nama	Jenis	Deskripsi
additionalInfo	ErrorAdditionalInfo[]	Info tambahan kesalahan.
code	string	Kode kesalahan.
details	ErrorDetail[]	Rincian kesalahan.
message	string	Pesan kesalahan.
target	string	Sasaran kesalahan.

ErrorResponse

Objek

Tanggapan kesalahan

Nama	Jenis	Deskripsi
error	ErrorDetail	Objek kesalahan.

FreeLimitExhaustionBehavior

Enumerasi

Menentukan perilaku ketika batas gratis bulanan habis untuk database gratis.

Jeda Otomatis: Database akan dijeda secara otomatis setelah kelelahan batas gratis selama sisa bulan.

BillForUsage: Database akan terus online setelah kelelahan batas gratis dan kelebihan biaya apa pun akan ditagih.

Nilai	Deskripsi
AutoPause	Jeda Otomatis
BillOverUsage	Penggunaan BillOverUsage

SampleName

Enumerasi

Nama skema sampel yang akan diterapkan saat membuat database ini.

Nilai	Deskripsi
AdventureWorksLT	AdventureWorksLT
WideWorldImportersStd	WideWorldImportirStd
WideWorldImportersFull	WideWorldImportirFull

SecondaryType

Enumerasi

Jenis database sekunder jika merupakan sekunder. Nilai yang valid adalah Geo, Bernama, dan Siaga.

Nilai	Deskripsi
Geo	Geo
Named	Dinamai
Standby	Siaga

Sku

Objek

Definisi model sumber daya yang mewakili SKU

Nama	Jenis	Deskripsi
capacity	integer (int32)	Jika SKU mendukung peluasan skala/masuk, bilangan bulat kapasitas harus disertakan. Jika peluasan/masuk skala tidak dimungkinkan untuk sumber daya, ini dapat dihilangkan.
family	string	Jika layanan memiliki generasi perangkat keras yang berbeda, untuk SKU yang sama, maka itu dapat ditangkap di sini.
name	string	Nama SKU. Misalnya P3. Biasanya kode huruf+angka
size	string	Ukuran SKU. Ketika bidang nama adalah kombinasi tingkatan dan beberapa nilai lainnya, ini akan menjadi kode mandiri.
tier	SkuTier	Bidang ini diperlukan untuk diimplementasikan oleh Penyedia Sumber Jika layanan memiliki lebih dari satu tingkat, tetapi tidak diperlukan pada PUT.

SkuTier

Enumerasi

Bidang ini diperlukan untuk diimplementasikan oleh Penyedia Sumber Jika layanan memiliki lebih dari satu tingkat, tetapi tidak diperlukan pada PUT.

Nilai	Deskripsi
Free
Basic
Standard
Premium

systemData

Objek

Metadata yang berkaitan dengan pembuatan dan modifikasi terakhir sumber daya.

Nama	Jenis	Deskripsi
createdAt	string (date-time)	Tanda waktu pembuatan sumber daya (UTC).
createdBy	string	Identitas yang membuat sumber daya tersebut.
createdByType	createdByType	Jenis identitas yang membuat sumber daya tersebut.
lastModifiedAt	string (date-time)	Tanda waktu modifikasi terakhir sumber daya (UTC)
lastModifiedBy	string	Identitas yang terakhir kali mengubah sumber daya.
lastModifiedByType	createdByType	Jenis identitas yang terakhir memodifikasi sumber daya.