sql_discovery_site_data_source_controllers

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

Overview

Name	sql_discovery_site_data_source_controllers
Type	Resource
Id	azure.migrate.sql_discovery_site_data_source_controllers

Fields

vw_sql_discovery_site_data_source_controllers

Name	Datatype	Description
discoverySiteDataSourceName	text	field from the properties object
discovery_site_id	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
sqlSiteName	text	field from the properties object
subscriptionId	text	field from the properties object

sql_discovery_site_data_source_controllers

Name	Datatype	Description
properties	object	Discovery site data source properties class.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	discoverySiteDataSourceName, resourceGroupName, siteName, sqlSiteName, subscriptionId	Get a SqlDiscoverySiteDataSource
list_by_sql_site	SELECT	resourceGroupName, siteName, sqlSiteName, subscriptionId	List SqlDiscoverySiteDataSource resources by SqlSite
create	INSERT	discoverySiteDataSourceName, resourceGroupName, siteName, sqlSiteName, subscriptionId	Create a SqlDiscoverySiteDataSource
delete	DELETE	discoverySiteDataSourceName, resourceGroupName, siteName, sqlSiteName, subscriptionId	Delete a SqlDiscoverySiteDataSource

SELECT examples

List SqlDiscoverySiteDataSource resources by SqlSite

vw_sql_discovery_site_data_source_controllers

SELECT
discoverySiteDataSourceName,
discovery_site_id,
provisioning_state,
resourceGroupName,
siteName,
sqlSiteName,
subscriptionId
FROM azure.migrate.vw_sql_discovery_site_data_source_controllers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_discovery_site_data_source_controllers

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: discoverySiteId
          value: string
        - name: provisioningState
          value: []

DELETE example

Deletes the specified sql_discovery_site_data_source_controllers resource.

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