Skip to main content

vw_sql_databases_controllers

Creates, updates, deletes, gets or lists a vw_sql_databases_controllers resource.

Overview​

Namevw_sql_databases_controllers
TypeView
Idazure.migrate.vw_sql_databases_controllers

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.parentReplicaOverview') as "parent_replica_overview",
JSON_EXTRACT(properties, '$.isDatabaseHighlyAvailable') as "is_database_highly_available",
JSON_EXTRACT(properties, '$.fileMetadataList') as "file_metadata_list",
JSON_EXTRACT(properties, '$.hostname') as "hostname",
JSON_EXTRACT(properties, '$.sqlServerName') as "sql_server_name",
JSON_EXTRACT(properties, '$.status') as "status",
JSON_EXTRACT(properties, '$.sizeMb') as "size_mb",
JSON_EXTRACT(properties, '$.databaseName') as "database_name",
JSON_EXTRACT(properties, '$.sqlServerArmId') as "sql_server_arm_id",
JSON_EXTRACT(properties, '$.compatibilityLevel') as "compatibility_level",
JSON_EXTRACT(properties, '$.isDeleted') as "is_deleted",
JSON_EXTRACT(properties, '$.errors') as "errors",
JSON_EXTRACT(properties, '$.createdTimestamp') as "created_timestamp",
JSON_EXTRACT(properties, '$.updatedTimestamp') as "updated_timestamp",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
siteName,
sqlSiteName,
sqlDatabaseName
FROM azure.migrate.sql_databases_controllers
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND siteName = 'replace-me' AND sqlSiteName = 'replace-me';