MigrateSqlServerSqlDbTaskInput Class

Definition

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

public final class MigrateSqlServerSqlDbTaskInput extends SqlMigrationTaskInput
Inheritance
java.lang.Object
MigrateSqlServerSqlDbTaskInput

Inherited Members

SqlMigrationTaskInput.sourceConnectionInfo() SqlMigrationTaskInput.targetConnectionInfo() SqlMigrationTaskInput.validate() SqlMigrationTaskInput.withSourceConnectionInfo(SqlConnectionInfo sourceConnectionInfo) SqlMigrationTaskInput.withTargetConnectionInfo(SqlConnectionInfo targetConnectionInfo) java.lang.Object.clone() java.lang.Object.equals(java.lang.Object) java.lang.Object.finalize() java.lang.Object.getClass() java.lang.Object.hashCode() java.lang.Object.notify() java.lang.Object.notifyAll() java.lang.Object.toString() java.lang.Object.wait() java.lang.Object.wait(long) java.lang.Object.wait(long,int)

Constructors

MigrateSqlServerSqlDbTaskInput()

Methods

selectedDatabases()

Get the selectedDatabases property: Databases to migrate.

validate()

Validates the instance.

validationOptions()

Get the validationOptions property: 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.

withSelectedDatabases(List<MigrateSqlServerSqlDbDatabaseInput> selectedDatabases)

Set the selectedDatabases property: Databases to migrate.

withSourceConnectionInfo(SqlConnectionInfo sourceConnectionInfo)

Set the sourceConnectionInfo property: Information for connecting to source.

withTargetConnectionInfo(SqlConnectionInfo targetConnectionInfo)

Set the targetConnectionInfo property: Information for connecting to target.

withValidationOptions(MigrationValidationOptions validationOptions)

Set the validationOptions property: 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