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

The following fields are returned by SELECT queries:

get

Successfully retrieved the Migration Service.

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

list_by_resource_group

Successfully retrieved the Migration Services in the resource group.

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

list_by_subscription

Successfully retrieved the Migration Services in the Subscription.

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

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resourceGroupName, migrationServiceName, 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	resourceGroupName, migrationServiceName, subscriptionId		Create or Update Database Migration Service.
update	update	resourceGroupName, migrationServiceName, subscriptionId		Update Database Migration Service.
delete	delete	resourceGroupName, migrationServiceName, subscriptionId		Delete Database Migration Service.

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
migrationServiceName	string	Name of the Migration Service.
resourceGroupName	string	Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
subscriptionId	string	Subscription ID that identifies an Azure subscription.

SELECT examples

get

Retrieve the Database Migration Service

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

list_by_resource_group

Retrieve all migration services in the resource group.

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

list_by_subscription

Retrieve all migration services in the subscriptions.

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

INSERT examples

create_or_update

Create or Update Database Migration Service.

INSERT INTO azure.data_migration.migration_services (
data__location,
data__tags,
data__properties,
resourceGroupName,
migrationServiceName,
subscriptionId
)
SELECT 
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ migrationServiceName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type
;

Manifest

# Description fields are for documentation purposes
- name: migration_services
  props:
    - name: resourceGroupName
      value: string
      description: Required parameter for the migration_services resource.
    - name: migrationServiceName
      value: string
      description: Required parameter for the migration_services resource.
    - name: subscriptionId
      value: string
      description: Required parameter for the migration_services resource.
    - name: location
      value: string
    - name: tags
      value: object
    - name: properties
      value: object
      description: |
        The Migration Service properties.

UPDATE examples

update

Update Database Migration Service.

UPDATE azure.data_migration.migration_services
SET 
data__tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}' --required
AND migrationServiceName = '{{ migrationServiceName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
RETURNING
id,
name,
location,
properties,
systemData,
tags,
type;

DELETE examples

delete

Delete Database Migration Service.

DELETE FROM azure.data_migration.migration_services
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND migrationServiceName = '{{ migrationServiceName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;