MigrateSqlServerSqlDbTaskInput | @azure/arm-datamigration

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

Hierarchy

SqlMigrationTaskInput
- MigrateSqlServerSqlDbTaskInput

Index

Properties

selectedDatabases

selectedDatabases: MigrateSqlServerSqlDbDatabaseInput[]

Databases to migrate

sourceConnectionInfo

sourceConnectionInfo: SqlConnectionInfo

Information for connecting to source

targetConnectionInfo

targetConnectionInfo: SqlConnectionInfo

Information for connecting to target

Optional validationOptions

validationOptions: MigrationValidationOptions

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.