sql_sites_controllers

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

Overview

Name	sql_sites_controllers
Type	Resource
Id	azure.migrate.sql_sites_controllers

Fields

vw_sql_sites_controllers

Name	Datatype	Description
discovery_scenario	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
service_endpoint	text	field from the properties object
siteName	text	field from the properties object
site_appliance_properties_collection	text	field from the properties object
sqlSiteName	text	field from the properties object
subscriptionId	text	field from the properties object

sql_sites_controllers

Name	Datatype	Description
properties	object	Class for SQL site properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to get a site.
list_by_master_site	SELECT	resourceGroupName, siteName, subscriptionId	Method to get all sites.
create	INSERT	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to create a SQL site.
delete	DELETE	resourceGroupName, siteName, sqlSiteName, subscriptionId	Deletes the SQL site.
update	UPDATE	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to update an existing site.
error_summary	EXEC	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to get error summary from SQL site.
export_sql_server_errors	EXEC	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to generate report containing SQL servers.
export_sql_servers	EXEC	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to generate report containing SQL servers.
refresh	EXEC	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to refresh a site.
summary	EXEC	resourceGroupName, siteName, sqlSiteName, subscriptionId	Method to get site usage/summary.

SELECT examples

Method to get all sites.

vw_sql_sites_controllers

SELECT
discovery_scenario,
provisioning_state,
resourceGroupName,
service_endpoint,
siteName,
site_appliance_properties_collection,
sqlSiteName,
subscriptionId
FROM azure.migrate.vw_sql_sites_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_sites_controllers

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

INSERT example

Use the following StackQL query and manifest file to create a new sql_sites_controllers resource.

All Properties

/*+ create */
INSERT INTO azure.migrate.sql_sites_controllers (
resourceGroupName,
siteName,
sqlSiteName,
subscriptionId,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ siteName }}',
'{{ sqlSiteName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: siteAppliancePropertiesCollection
          value:
            - - name: servicePrincipalIdentityDetails
                value:
                  - name: tenantId
                    value: string
                  - name: applicationId
                    value: string
                  - name: objectId
                    value: string
                  - name: audience
                    value: string
                  - name: aadAuthority
                    value: string
                  - name: rawCertData
                    value: string
              - name: agentDetails
                value:
                  - name: id
                    value: string
                  - name: version
                    value: string
                  - name: lastHeartBeatUtc
                    value: string
                  - name: keyVaultUri
                    value: string
                  - name: keyVaultId
                    value: string
              - name: applianceName
                value: string
        - name: discoveryScenario
          value: []
        - name: serviceEndpoint
          value: string
        - name: provisioningState
          value: []

UPDATE example

Updates a sql_sites_controllers resource.

/*+ update */
UPDATE azure.migrate.sql_sites_controllers
SET 
properties = '{{ properties }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified sql_sites_controllers resource.

/*+ delete */
DELETE FROM azure.migrate.sql_sites_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';