New-AzDataMigrationToSqlVM

New-AzDataMigrationToSqlVM
    -ResourceGroupName <String>
    -SqlVirtualMachineName <String>
    -TargetDbName <String>
    [-SubscriptionId <String>]
    [-AzureBlobAccountKey <String>]
    [-AzureBlobContainerName <String>]
    [-AzureBlobStorageAccountResourceId <String>]
    [-FileSharePassword <SecureString>]
    [-FileSharePath <String>]
    [-FileShareUsername <String>]
    [-Kind <ResourceType>]
    [-MigrationService <String>]
    [-Offline]
    [-OfflineConfigurationLastBackupName <String>]
    [-Scope <String>]
    [-SourceDatabaseName <String>]
    [-SourceSqlConnectionAuthentication <String>]
    [-SourceSqlConnectionDataSource <String>]
    [-SourceSqlConnectionEncryptConnection]
    [-SourceSqlConnectionPassword <SecureString>]
    [-SourceSqlConnectionTrustServerCertificate]
    [-SourceSqlConnectionUserName <String>]
    [-StorageAccountKey <String>]
    [-StorageAccountResourceId <String>]
    [-TargetDatabaseCollation <String>]
    [-DefaultProfile <PSObject>]
    [-AsJob]
    [-NoWait]
    [-PassThru]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

创建新的数据库迁移到给定的 SQL VM。

$sourcePassword = ConvertTo-SecureString -String $password -AsPlainText -Force
$filesharePassword = ConvertTo-SecureString -String $password -AsPlainText -Force

New-AzDataMigrationToSqlVM -ResourceGroupName "MyResourceGroup" -SqlVirtualMachineName "MyVM" -TargetDbName "MyDb" -Kind "SqlVm" -Scope "/subscriptions/0000-1111-2222-3333-4444/resourceGroups/MyResourceGroup/providers/Microsoft.SqlVirtualMachine/sqlVirtualMachine/MyVM" -MigrationService "/subscriptions/0000-1111-2222-3333-4444/resourceGroups/MyResourceGroup/providers/Microsoft.DataMigration/SqlMigrationServices/MySqlMigrationService" -StorageAccountResourceId "/subscriptions/0000-1111-2222-3333-4444/resourceGroups/MyResourceGroup/providers/Microsoft.Storage/storageAccounts/MyStorageAccount" -StorageAccountKey "aaaaaccccoooouuunnntttkkkeeeyy" -FileSharePath "\\filesharepath.com\SharedBackup\MyBackUps" -FileShareUsername "filesharepath\User" -FileSharePassword $filesharePassword -SourceSqlConnectionAuthentication "SqlAuthentication" -SourceSqlConnectionDataSource "LabServer.database.net" -SourceSqlConnectionUserName "User" -SourceSqlConnectionPassword $sourcePassword -SourceDatabaseName "AdventureWorks"

Name                 Type                                       Kind  ProvisioningState MigrationStatus
----                 ----                                       ----  ----------------- ---------------
MyDb                 Microsoft.DataMigration/databaseMigrations SqlVm Succeeded         InProgress

此命令启动从源 Sql Server 到目标 Sql VM 的数据库迁移。 此示例适用于联机迁移。 若要使其脱机，请将 -Offline 添加到参数。

注意：创建新的数据库迁移到给定的 SQL VM。 注意 - 对于 Scope 参数，请使用 SQL VM 的范围（/subscriptions/111-222/resourceGroups/myRG/providers/Microsoft。SqlVirtualMachine/SqlVirtualMachines/xyz-SqlVM）而不是计算 SQL VM（/subscriptions/111-222/resourceGroups/myRG/providers/Microsoft。Compute/virtualMachines/xyz-SqlVM）

此 cmdlet 支持通用参数：-Debug、-ErrorAction、-ErrorVariable、-InformationAction、-InformationVariable、-OutBuffer、-OutVariable、-PipelineVariable、-ProgressAction、-Verbose、-WarningAction 和 -WarningVariable。 有关详细信息，请参阅 about_CommonParameters。