MigrateSqlServerSqlDbTaskInput Class

public final class MigrateSqlServerSqlDbTaskInput
extends SqlMigrationTaskInput

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

Constructor Summary

Constructor Description
MigrateSqlServerSqlDbTaskInput()

Creates an instance of MigrateSqlServerSqlDbTaskInput class.

Method Summary

Modifier and Type Method and Description
List<MigrateSqlServerSqlDbDatabaseInput> selectedDatabases()

Get the selectedDatabases property: Databases to migrate.

void validate()

Validates the instance.

MigrationValidationOptions validationOptions()

Get the validationOptions property: Options for enabling various post migration validations.

MigrateSqlServerSqlDbTaskInput withSelectedDatabases(List<MigrateSqlServerSqlDbDatabaseInput> selectedDatabases)

Set the selectedDatabases property: Databases to migrate.

MigrateSqlServerSqlDbTaskInput withSourceConnectionInfo(SqlConnectionInfo sourceConnectionInfo)

Set the sourceConnectionInfo property: Information for connecting to source.

MigrateSqlServerSqlDbTaskInput withTargetConnectionInfo(SqlConnectionInfo targetConnectionInfo)

Set the targetConnectionInfo property: Information for connecting to target.

MigrateSqlServerSqlDbTaskInput withValidationOptions(MigrationValidationOptions validationOptions)

Set the validationOptions property: Options for enabling various post migration validations.

Methods inherited from SqlMigrationTaskInput

Methods inherited from java.lang.Object

Constructor Details

MigrateSqlServerSqlDbTaskInput

public MigrateSqlServerSqlDbTaskInput()

Creates an instance of MigrateSqlServerSqlDbTaskInput class.

Method Details

selectedDatabases

public List selectedDatabases()

Get the selectedDatabases property: Databases to migrate.

Returns:

the selectedDatabases value.

validate

public void validate()

Validates the instance.

Overrides:

MigrateSqlServerSqlDbTaskInput.validate()

validationOptions

public MigrationValidationOptions 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.

Returns:

the validationOptions value.

withSelectedDatabases

public MigrateSqlServerSqlDbTaskInput withSelectedDatabases(List selectedDatabases)

Set the selectedDatabases property: Databases to migrate.

Parameters:

selectedDatabases - the selectedDatabases value to set.

Returns:

the MigrateSqlServerSqlDbTaskInput object itself.

withSourceConnectionInfo

public MigrateSqlServerSqlDbTaskInput withSourceConnectionInfo(SqlConnectionInfo sourceConnectionInfo)

Set the sourceConnectionInfo property: Information for connecting to source.

Overrides:

MigrateSqlServerSqlDbTaskInput.withSourceConnectionInfo(SqlConnectionInfo sourceConnectionInfo)

Parameters:

sourceConnectionInfo

withTargetConnectionInfo

public MigrateSqlServerSqlDbTaskInput withTargetConnectionInfo(SqlConnectionInfo targetConnectionInfo)

Set the targetConnectionInfo property: Information for connecting to target.

Overrides:

MigrateSqlServerSqlDbTaskInput.withTargetConnectionInfo(SqlConnectionInfo targetConnectionInfo)

Parameters:

targetConnectionInfo

withValidationOptions

public MigrateSqlServerSqlDbTaskInput 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.

Parameters:

validationOptions - the validationOptions value to set.

Returns:

the MigrateSqlServerSqlDbTaskInput object itself.

Applies to