managed_database_move_operations

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

Overview

Name	managed_database_move_operations
Type	Resource
Id	azure.sql.managed_database_move_operations

Fields

vw_managed_database_move_operations

Name	Datatype	Description
error_code	text	field from the properties object
error_description	text	field from the properties object
error_severity	text	field from the properties object
is_cancellable	text	field from the properties object
is_user_error	text	field from the properties object
locationName	text	field from the properties object
operation	text	field from the properties object
operationId	text	field from the properties object
operation_friendly_name	text	field from the properties object
operation_mode	text	field from the properties object
resourceGroupName	text	field from the properties object
source_database_name	text	field from the properties object
source_managed_instance_id	text	field from the properties object
source_managed_instance_name	text	field from the properties object
start_time	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
target_database_name	text	field from the properties object
target_managed_instance_id	text	field from the properties object
target_managed_instance_name	text	field from the properties object

managed_database_move_operations

Name	Datatype	Description
properties	object	Contains the operation result properties for managed database move operation.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	locationName, operationId, resourceGroupName, subscriptionId	Gets a managed database move operation.
list_by_location	SELECT	locationName, resourceGroupName, subscriptionId	Lists managed database move operations.

SELECT examples

Lists managed database move operations.

vw_managed_database_move_operations

SELECT
error_code,
error_description,
error_severity,
is_cancellable,
is_user_error,
locationName,
operation,
operationId,
operation_friendly_name,
operation_mode,
resourceGroupName,
source_database_name,
source_managed_instance_id,
source_managed_instance_name,
start_time,
state,
subscriptionId,
target_database_name,
target_managed_instance_id,
target_managed_instance_name
FROM azure.sql.vw_managed_database_move_operations
WHERE locationName = '{{ locationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_database_move_operations

SELECT
properties
FROM azure.sql.managed_database_move_operations
WHERE locationName = '{{ locationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';