migration_services

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

Overview

Name	migration_services
Type	Resource
Id	azure.data_migration.migration_services

Fields

vw_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
migrationServiceName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	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

migration_services

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	migrationServiceName, resourceGroupName, subscriptionId	Retrieve the Database Migration Service
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Retrieve all migration services in the resource group.
list_by_subscription	SELECT	subscriptionId	Retrieve all migration services in the subscriptions.
create_or_update	INSERT	migrationServiceName, resourceGroupName, subscriptionId	Create or Update Database Migration Service.
delete	DELETE	migrationServiceName, resourceGroupName, subscriptionId	Delete Database Migration Service.
update	UPDATE	migrationServiceName, resourceGroupName, subscriptionId	Update Database Migration Service.

SELECT examples

Retrieve all migration services in the subscriptions.

vw_migration_services

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

migration_services

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.data_migration.migration_services (
migrationServiceName,
resourceGroupName,
subscriptionId,
location,
tags,
properties
)
SELECT 
'{{ migrationServiceName }}',
'{{ resourceGroupName }}',
'{{ 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 migration_services resource.

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

DELETE example

Deletes the specified migration_services resource.

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