Skip to main content

sql_migration_services_migrations

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

Overview

Namesql_migration_services_migrations
TypeResource
Idazure.data_migration.sql_migration_services_migrations

Fields

NameDatatypeDescription
idstring
namestring
propertiesobjectDatabase Migration Resource properties.
systemDataobject
typestring

Methods

NameAccessible byRequired ParamsDescription
listSELECTresourceGroupName, sqlMigrationServiceName, subscriptionIdRetrieve the List of database migrations attached to the service.

SELECT examples

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 }}'
AND sqlMigrationServiceName = '{{ sqlMigrationServiceName }}'
AND subscriptionId = '{{ subscriptionId }}';