Share via

MigrateSqlServerSqlDbTaskInput interface

Package:
@azure/arm-datamigration

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

Extends
SqlMigrationTaskInput

Properties

encryptedKeyForSecureFields

encrypted key for secure fields
selectedDatabases

Databases to migrate
startedOn

Date and time relative to UTC when the migration was started on
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

encryptedKeyForSecureFields

encrypted key for secure fields

encryptedKeyForSecureFields?: string

Property Value

string

selectedDatabases

Databases to migrate

selectedDatabases: MigrateSqlServerSqlDbDatabaseInput[]

Property Value

MigrateSqlServerSqlDbDatabaseInput[]

startedOn

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

startedOn?: string

Property Value

string

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