MigrateSqlServerSqlDbTaskInput Constructors
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| MigrateSqlServerSqlDbTaskInput() |
Initializes a new instance of the MigrateSqlServerSqlDbTaskInput class. |
| MigrateSqlServerSqlDbTaskInput(SqlConnectionInfo, SqlConnectionInfo, IList<MigrateSqlServerSqlDbDatabaseInput>, MigrationValidationOptions) |
Initializes a new instance of the MigrateSqlServerSqlDbTaskInput class. |
MigrateSqlServerSqlDbTaskInput()
Initializes a new instance of the MigrateSqlServerSqlDbTaskInput class.
public MigrateSqlServerSqlDbTaskInput ();Public Sub New ()Applies to
MigrateSqlServerSqlDbTaskInput(SqlConnectionInfo, SqlConnectionInfo, IList<MigrateSqlServerSqlDbDatabaseInput>, MigrationValidationOptions)
Initializes a new instance of the MigrateSqlServerSqlDbTaskInput class.
public MigrateSqlServerSqlDbTaskInput (Microsoft.Azure.Management.DataMigration.Models.SqlConnectionInfo sourceConnectionInfo, Microsoft.Azure.Management.DataMigration.Models.SqlConnectionInfo targetConnectionInfo, System.Collections.Generic.IList<Microsoft.Azure.Management.DataMigration.Models.MigrateSqlServerSqlDbDatabaseInput> selectedDatabases, Microsoft.Azure.Management.DataMigration.Models.MigrationValidationOptions validationOptions = default);new Microsoft.Azure.Management.DataMigration.Models.MigrateSqlServerSqlDbTaskInput : Microsoft.Azure.Management.DataMigration.Models.SqlConnectionInfo * Microsoft.Azure.Management.DataMigration.Models.SqlConnectionInfo * System.Collections.Generic.IList<Microsoft.Azure.Management.DataMigration.Models.MigrateSqlServerSqlDbDatabaseInput> * Microsoft.Azure.Management.DataMigration.Models.MigrationValidationOptions -> Microsoft.Azure.Management.DataMigration.Models.MigrateSqlServerSqlDbTaskInputPublic Sub New (sourceConnectionInfo As SqlConnectionInfo, targetConnectionInfo As SqlConnectionInfo, selectedDatabases As IList(Of MigrateSqlServerSqlDbDatabaseInput), Optional validationOptions As MigrationValidationOptions = Nothing)Parameters
- sourceConnectionInfo
- SqlConnectionInfo
Information for connecting to source
- targetConnectionInfo
- SqlConnectionInfo
Information for connecting to target
- selectedDatabases
- IList<MigrateSqlServerSqlDbDatabaseInput>
Databases to migrate
- 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.