Skip to main content

vw_managed_database_move_operations

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

Overview​

Namevw_managed_database_move_operations
TypeView
Idazure.sql.vw_managed_database_move_operations

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.operation') as "operation",
JSON_EXTRACT(properties, '$.operationFriendlyName') as "operation_friendly_name",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.operationMode') as "operation_mode",
JSON_EXTRACT(properties, '$.sourceManagedInstanceName') as "source_managed_instance_name",
JSON_EXTRACT(properties, '$.targetManagedInstanceName') as "target_managed_instance_name",
JSON_EXTRACT(properties, '$.sourceManagedInstanceId') as "source_managed_instance_id",
JSON_EXTRACT(properties, '$.targetManagedInstanceId') as "target_managed_instance_id",
JSON_EXTRACT(properties, '$.sourceDatabaseName') as "source_database_name",
JSON_EXTRACT(properties, '$.targetDatabaseName') as "target_database_name",
JSON_EXTRACT(properties, '$.isCancellable') as "is_cancellable",
JSON_EXTRACT(properties, '$.errorCode') as "error_code",
JSON_EXTRACT(properties, '$.errorDescription') as "error_description",
JSON_EXTRACT(properties, '$.errorSeverity') as "error_severity",
JSON_EXTRACT(properties, '$.isUserError') as "is_user_error",
subscriptionId,
resourceGroupName,
locationName,
operationId
FROM azure.sql.managed_database_move_operations
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND locationName = 'replace-me';