Get-AzDataMigrationSqlServiceMigration
Retrieve the List of database migrations attached to the service.
Syntax
Default (Default)
Get-AzDataMigrationSqlServiceMigration
-ResourceGroupName <String>
-SqlMigrationServiceName <String>
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[-PassThru]
[<CommonParameters>]
Description
Retrieve the List of database migrations attached to the service.
Examples
Example 1: Get the list of database migrations attached to a given Sql Migration Service
Get-AzDataMigrationSqlServiceMigration -ResourceGroupName "MyResourceGroup" -SqlMigrationServiceName "MySqlMigrationService"
Name Type Kind ProvisioningState MigrationStatus
---- ---- ---- ----------------- ---------------
MyDatabase Microsoft.DataMigration/databaseMigrations SqlMi Succeeded InProgress
MyDatabaseSqlMi Microsoft.DataMigration/databaseMigrations SqlMi Succeeded Succeeded
MyDatabaseSqlVM Microsoft.DataMigration/databaseMigrations SqlVm Succeeded Succeeded
This command gets the list of database migrations attached to a given Sql Migration service.
Parameters
-DefaultProfile
The DefaultProfile parameter is not functional. Use the SubscriptionId parameter when available if executing the cmdlet against a different subscription.
Parameter properties
| Type: | PSObject |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | AzureRMContext, AzureCredential |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-PassThru
Returns true when the command succeeds
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-ResourceGroupName
Name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API or the portal.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-SqlMigrationServiceName
Name of the SQL Migration Service.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-SubscriptionId
Subscription ID that identifies an Azure subscription.
Parameter properties
| Type: | String[] |
| Default value: | (Get-AzContext).Subscription.Id |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
