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

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, discoverySiteDataSourceName		Get a SqlDiscoverySiteDataSource
list_by_sql_site	select	subscriptionId, resourceGroupName, siteName, sqlSiteName		List SqlDiscoverySiteDataSource resources by SqlSite
create	insert	subscriptionId, resourceGroupName, siteName, sqlSiteName, discoverySiteDataSourceName		Create a SqlDiscoverySiteDataSource
delete	delete	subscriptionId, resourceGroupName, siteName, sqlSiteName, discoverySiteDataSourceName		Delete a SqlDiscoverySiteDataSource

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
discoverySiteDataSourceName	string	SQL Discovery site data source name.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
siteName	string	Site name
sqlSiteName	string	SQL site name.
subscriptionId	string	The ID of the target subscription.

SELECT examples

get

Get a SqlDiscoverySiteDataSource

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

list_by_sql_site

List SqlDiscoverySiteDataSource resources by SqlSite

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

INSERT examples

create

Create a SqlDiscoverySiteDataSource

INSERT INTO azure.migrate.sql_discovery_site_data_source_controllers (
data__properties,
subscriptionId,
resourceGroupName,
siteName,
sqlSiteName,
discoverySiteDataSourceName
)
SELECT 
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ siteName }}',
'{{ sqlSiteName }}',
'{{ discoverySiteDataSourceName }}'
RETURNING
properties
;

Manifest

# Description fields are for documentation purposes
- name: sql_discovery_site_data_source_controllers
  props:
    - name: subscriptionId
      value: string
      description: Required parameter for the sql_discovery_site_data_source_controllers resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the sql_discovery_site_data_source_controllers resource.
    - name: siteName
      value: string
      description: Required parameter for the sql_discovery_site_data_source_controllers resource.
    - name: sqlSiteName
      value: string
      description: Required parameter for the sql_discovery_site_data_source_controllers resource.
    - name: discoverySiteDataSourceName
      value: string
      description: Required parameter for the sql_discovery_site_data_source_controllers resource.
    - name: properties
      value: object
      description: |
        The resource-specific properties for this resource.

DELETE examples

delete

Delete a SqlDiscoverySiteDataSource

DELETE FROM azure.migrate.sql_discovery_site_data_source_controllers
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND siteName = '{{ siteName }}' --required
AND sqlSiteName = '{{ sqlSiteName }}' --required
AND discoverySiteDataSourceName = '{{ discoverySiteDataSourceName }}' --required
;