sql_migration_services

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

Overview

Name	sql_migration_services
Type	Resource
Id	azure.data_migration.sql_migration_services

Fields

vw_sql_migration_services

Name	Datatype	Description
id	text	field from the properties object
name	text	field from the properties object
integration_runtime_state	text	field from the properties object
location	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
sqlMigrationServiceName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	field from the properties object
type	text	field from the properties object

sql_migration_services

Name	Datatype	Description
id	string
name	string
location	string
properties	object	The SQL Migration Service properties.
systemData	object
tags	object
type	string

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlMigrationServiceName, subscriptionId	Retrieve the Database Migration Service
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Retrieve all SQL migration services in the resource group.
list_by_subscription	SELECT	subscriptionId	Retrieve all SQL migration services in the subscriptions.
create_or_update	INSERT	resourceGroupName, sqlMigrationServiceName, subscriptionId	Create or Update Database Migration Service.
delete	DELETE	resourceGroupName, sqlMigrationServiceName, subscriptionId	Delete Database Migration Service.
update	UPDATE	resourceGroupName, sqlMigrationServiceName, subscriptionId	Update Database Migration Service.
delete_node	EXEC	resourceGroupName, sqlMigrationServiceName, subscriptionId	Delete the integration runtime node.
regenerate_auth_keys	EXEC	resourceGroupName, sqlMigrationServiceName, subscriptionId	Regenerate a new set of Authentication Keys for Self Hosted Integration Runtime.

SELECT examples

Retrieve all SQL migration services in the subscriptions.

vw_sql_migration_services

SELECT
id,
name,
integration_runtime_state,
location,
provisioning_state,
resourceGroupName,
sqlMigrationServiceName,
subscriptionId,
system_data,
tags,
type
FROM azure.data_migration.vw_sql_migration_services
WHERE subscriptionId = '{{ subscriptionId }}';

sql_migration_services

SELECT
id,
name,
location,
properties,
systemData,
tags,
type
FROM azure.data_migration.sql_migration_services
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_migration.sql_migration_services (
resourceGroupName,
sqlMigrationServiceName,
subscriptionId,
location,
tags,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ sqlMigrationServiceName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: location
      value: string
    - name: tags
      value: object
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: integrationRuntimeState
          value: string

UPDATE example

Updates a sql_migration_services resource.

/*+ update */
UPDATE azure.data_migration.sql_migration_services
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND sqlMigrationServiceName = '{{ sqlMigrationServiceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified sql_migration_services resource.

/*+ delete */
DELETE FROM azure.data_migration.sql_migration_services
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlMigrationServiceName = '{{ sqlMigrationServiceName }}'
AND subscriptionId = '{{ subscriptionId }}';