New-AzDataMigrationTdeCertificateMigration

Reference

Module:: Az.DataMigration

Migrate TDE certificate(s) from source SQL Server to the target Azure SQL Server.

Syntax

New-AzDataMigrationTdeCertificateMigration
   -SourceSqlConnectionString <SecureString>
   -TargetSubscriptionId <String>
   -TargetResourceGroupName <String>
   -TargetManagedInstanceName <String>
   -NetworkSharePath <String>
   -NetworkShareDomain <String>
   -DatabaseName <String[]>
   [-NetworkShareUserName <String>]
   [-NetworkSharePassword <SecureString>]
   [-PassThru]
   [-WhatIf]
   [-Confirm]
   [<CommonParameters>]

Description

Migrate TDE certificate(s) from source SQL Server to the target Azure SQL Server.

Examples

Example 1: Run TDE certificate migration from a source SQL Server to a target Azure SQL Server.

New-AzDataMigrationTdeCertificateMigration -SourceSqlConnectionString "data source=servername;user id=userid;password=;initial catalog=master;TrustServerCertificate=True" -TargetSubscriptionId "00000000-0000-0000-0000-000000000000" -TargetResourceGroupName "ResourceGroupName" -TargetManagedInstanceName "TargetManagedInstanceName" -NetworkSharePath "\\NetworkShare\Folder" -NetworkShareDomain "NetworkShare" -NetworkShareUserName "NetworkShareUserName" -NetworkSharePassword "NetworkSharePassword" -DatabaseName "TdeDb_0", "TdeDb_1", "TdeDb_2"

Beginning TDE certificate migration
TdeDb_0: TDE certificate migrated successfully.
TdeDb_1: TDE certificate migrated successfully.
TdeDb_2: TDE certificate migrated successfully.
Certificate migration completed

This command runs TDE certificate migration from a source SQL Server to a target Azure SQL Server.

Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DatabaseName

Source database name.

Type:	String[]
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-NetworkShareDomain

Network share domain.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-NetworkSharePassword

Network share password.

Type:	SecureString
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-NetworkSharePath

Network share path.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-NetworkShareUserName

Network share user name.

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-PassThru

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SourceSqlConnectionString

Required. Connection string for the source SQL instance, using the formal connection string format.

Type:	SecureString
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-TargetManagedInstanceName

Name of the Azure SQL Server.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-TargetResourceGroupName

Resource group name of the target Azure SQL server.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-TargetSubscriptionId

Subscription Id of the target Azure SQL server.

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

Outputs

Boolean

Dela via