mirror of
https://github.com/hanzoai/azure-sdk-for-js.git
synced 2026-10-30 19:51:51 +00:00
Configurations: 'specification/sql/resource-manager/Microsoft.Sql/SQL/tspconfig.yaml', API Version: 2025-01-01, SDK Release Type: stable, and CommitSHA: '41784cfad64229e05cb37b1532a686a0cc3a60a9` in SpecRepo: 'https://github.com/Azure/azure-rest-api-specs' Pipeline run: https://dev.azure.com/azure-sdk/internal/_build/results?buildId=6276195 Refer to https://eng.ms/docs/products/azure-developer-experience/develop/sdk-release/sdk-release-prerequisites to prepare for SDK release. Release plan link: [https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu](https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu.westus-01.azurewebsites.net/?releasePlan=2227).[westus-01.azurewebsites.net/?releasePlan=2227](https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu.westus-01.azurewebsites.net/?releasePlan=2227) Submitted by: [[email protected]](mailto:[email protected]) ### Release Plan Details Release Plan: https://azsdk-releaseplan-dashboard-hveph5aqhhcfhtgu.westus-01.azurewebsites.net/?releasePlan=2227 Spec pull request: [Azure/azure-rest-api-specs#41520](https://github.com/Azure/azure-rest-api-specs/pull/41520) Spec API version: --------- Co-authored-by: kazrael2119 <[email protected]>
608 lines
23 KiB
TypeScript
608 lines
23 KiB
TypeScript
// Copyright (c) Microsoft Corporation.
|
|
// Licensed under the MIT License.
|
|
|
|
import { SqlManagementClient } from "@azure/arm-sql";
|
|
import { DefaultAzureCredential } from "@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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
/**
|
|
* 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(): Promise<void> {
|
|
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);
|
|
}
|
|
|
|
async function main(): Promise<void> {
|
|
await createsADatabaseWithSpecifiedBackupStorageRedundancy();
|
|
await createsADatabaseAsACopy();
|
|
await createsADatabaseWithDefaultEnclaveType();
|
|
await createsADatabaseWithDefaultMode();
|
|
await createsADatabaseWithDatabaseLevelCustomerManagedKeys();
|
|
await createsADatabaseWithDatabaseLevelVersionlessCustomerManagedKeys();
|
|
await createsADatabaseWithLedgerOn();
|
|
await createsADatabaseWithPreferredMaintenanceWindow();
|
|
await createsADatabaseWithMinimumNumberOfParameters();
|
|
await createsADatabaseAsNamedReplicaSecondary();
|
|
await createsADatabaseFromPointInTimeRestore();
|
|
await createsADatabaseAsAnOnLineSecondary();
|
|
await createsADatabaseAsAStandbySecondary();
|
|
await createsADatabaseWithVBSEnclaveType();
|
|
await createsADatabaseWithAvailabilityZoneSpecified();
|
|
await createsADatabaseWithEncryptionProtectorAutoRotation();
|
|
await createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromARestorePointOfAnExistingDatabase();
|
|
await createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromAGeoBackup();
|
|
await createsADataWarehouseDatabaseAsACrossSubscriptionRestoreFromABackupOfADroppedDatabase();
|
|
await createsAVCoreDatabaseBySpecifyingServiceObjectiveName();
|
|
await createsAVCoreDatabaseBySpecifyingSkuNameAndCapacity();
|
|
await updatesADatabaseToHyperscaleTierByTriggeringManualCutoverDuringMigrationWorkflow();
|
|
await updatesADatabaseToHyperscaleSLOWithManualCutover();
|
|
}
|
|
|
|
main().catch(console.error);
|