sql_migration_services_migrations

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

Overview

Name	sql_migration_services_migrations
Type	Resource
Id	azure.data_migration.sql_migration_services_migrations

Fields

The following fields are returned by SELECT queries:

list

Successfully return of migrations attached to the service.

Name	Datatype	Description
id	string
name	string
properties	object	Database Migration Resource properties.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	resourceGroupName, sqlMigrationServiceName, subscriptionId		Retrieve the List of database migrations attached to the 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
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.
sqlMigrationServiceName	string	Name of the SQL Migration Service.
subscriptionId	string	Subscription ID that identifies an Azure subscription.

SELECT examples

list

Retrieve the List of database migrations attached to the service.

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