sql_databases_controllers

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

Overview

Name	sql_databases_controllers
Type	Resource
Id	azure.migrate.sql_databases_controllers

Fields

vw_sql_databases_controllers

Name	Datatype	Description
compatibility_level	text	field from the properties object
created_timestamp	text	field from the properties object
database_name	text	field from the properties object
errors	text	field from the properties object
file_metadata_list	text	field from the properties object
hostname	text	field from the properties object
is_database_highly_available	text	field from the properties object
is_deleted	text	field from the properties object
parent_replica_overview	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
siteName	text	field from the properties object
size_mb	text	field from the properties object
sqlDatabaseName	text	field from the properties object
sqlSiteName	text	field from the properties object
sql_server_arm_id	text	field from the properties object
sql_server_name	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
updated_timestamp	text	field from the properties object

sql_databases_controllers

Name	Datatype	Description
properties	object	Class for SQL Server database properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, siteName, sqlDatabaseName, sqlSiteName, subscriptionId	Gets the sql Database.
list_by_sql_site	SELECT	resourceGroupName, siteName, sqlSiteName, subscriptionId	Gets the sql Databases.

SELECT examples

Gets the sql Databases.

vw_sql_databases_controllers

SELECT
compatibility_level,
created_timestamp,
database_name,
errors,
file_metadata_list,
hostname,
is_database_highly_available,
is_deleted,
parent_replica_overview,
provisioning_state,
resourceGroupName,
siteName,
size_mb,
sqlDatabaseName,
sqlSiteName,
sql_server_arm_id,
sql_server_name,
status,
subscriptionId,
updated_timestamp
FROM azure.migrate.vw_sql_databases_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_databases_controllers

SELECT
properties
FROM azure.migrate.sql_databases_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';