MigrateSqlServerSqlDBTaskInput Class

Definition

Input for the task that migrates on-prem SQL Server databases to Azure SQL Database.

public class MigrateSqlServerSqlDBTaskInput : Azure.ResourceManager.DataMigration.Models.SqlMigrationTaskInput
type MigrateSqlServerSqlDBTaskInput = class
    inherit SqlMigrationTaskInput
Public Class MigrateSqlServerSqlDBTaskInput
Inherits SqlMigrationTaskInput
Inheritance
MigrateSqlServerSqlDBTaskInput

Constructors

MigrateSqlServerSqlDBTaskInput(SqlConnectionInfo, SqlConnectionInfo, IEnumerable<MigrateSqlServerSqlDBDatabaseInput>)

Initializes a new instance of MigrateSqlServerSqlDBTaskInput.

Properties

EncryptedKeyForSecureFields

encrypted key for secure fields.

SelectedDatabases

Databases to migrate.

SourceConnectionInfo

Information for connecting to source.

(Inherited from SqlMigrationTaskInput)
StartedOn

Date and time relative to UTC when the migration was started on.

TargetConnectionInfo

Information for connecting to target.

(Inherited from SqlMigrationTaskInput)
ValidationOptions

Options for enabling various post migration validations. Available options, 1.) Data Integrity Check: Performs a checksum based comparison on source and target tables after the migration to ensure the correctness of the data. 2.) Schema Validation: Performs a thorough schema comparison between the source and target tables and provides a list of differences between the source and target database, 3.) Query Analysis: Executes a set of queries picked up automatically either from the Query Plan Cache or Query Store and execute them and compares the execution time between the source and target database.

Applies to