Share via

MigrateSqlServerSqlDbTaskInput interface

  • Reference
Package:
@azure/arm-datamigration

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

Extends
SqlMigrationTaskInput

Properties

selectedDatabases

Databases to migrate
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.

Inherited Properties

sourceConnectionInfo

Information for connecting to source
targetConnectionInfo

Information for connecting to target

Property Details

selectedDatabases

Databases to migrate

selectedDatabases: MigrateSqlServerSqlDbDatabaseInput[]

Property Value

MigrateSqlServerSqlDbDatabaseInput[]

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.

validationOptions?: MigrationValidationOptions

Property Value

MigrationValidationOptions

Inherited Property Details

sourceConnectionInfo

Information for connecting to source

sourceConnectionInfo: SqlConnectionInfo

Property Value

SqlConnectionInfo

Inherited From SqlMigrationTaskInput.sourceConnectionInfo

targetConnectionInfo

Information for connecting to target

targetConnectionInfo: SqlConnectionInfo

Property Value

SqlConnectionInfo

Inherited From SqlMigrationTaskInput.targetConnectionInfo