sql_servers_controllers

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

Overview

Name	sql_servers_controllers
Type	Resource
Id	azure.migrate.sql_servers_controllers

Fields

The following fields are returned by SELECT queries:

get

ARM operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

list_by_sql_site

ARM operation completed successfully.

Name	Datatype	Description
properties	object	The resource-specific properties for this resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, siteName, sqlSiteName, sqlServerName		Gets the sql server.
list_by_sql_site	select	subscriptionId, resourceGroupName, siteName, sqlSiteName	filter, top, continuationToken, totalRecordCount	Gets the sql servers.
update	update	subscriptionId, resourceGroupName, siteName, sqlSiteName, sqlServerName		Updates the sql server tags.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resourceGroupName	string	The name of the resource group. The name is case insensitive.
siteName	string	Site name
sqlServerName	string	SQL server name.
sqlSiteName	string	SQL site name.
subscriptionId	string	The ID of the target subscription.
continuationToken	string	Optional parameter for continuation token.
filter	string	filter query
top	string	page size query
totalRecordCount	integer (int32)	Total count of machines in the given site.

SELECT examples

get

Gets the sql server.

SELECT
properties
FROM azure.migrate.sql_servers_controllers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND siteName = '{{ siteName }}' -- required
AND sqlSiteName = '{{ sqlSiteName }}' -- required
AND sqlServerName = '{{ sqlServerName }}' -- required
;

list_by_sql_site

Gets the sql servers.

SELECT
properties
FROM azure.migrate.sql_servers_controllers
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND siteName = '{{ siteName }}' -- required
AND sqlSiteName = '{{ sqlSiteName }}' -- required
AND filter = '{{ filter }}'
AND top = '{{ top }}'
AND continuationToken = '{{ continuationToken }}'
AND totalRecordCount = '{{ totalRecordCount }}'
;

UPDATE examples

update

Updates the sql server tags.

UPDATE azure.migrate.sql_servers_controllers
SET 
data__properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND siteName = '{{ siteName }}' --required
AND sqlSiteName = '{{ sqlSiteName }}' --required
AND sqlServerName = '{{ sqlServerName }}' --required
RETURNING
properties;