MigrateSqlServerSqlDbTaskInput Class
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.
Input for the task that migrates on-prem SQL Server databases to Azure SQL Database
public class MigrateSqlServerSqlDbTaskInput : Microsoft.Azure.Management.DataMigration.Models.SqlMigrationTaskInputtype MigrateSqlServerSqlDbTaskInput = class
inherit SqlMigrationTaskInputPublic Class MigrateSqlServerSqlDbTaskInput
Inherits SqlMigrationTaskInput- Inheritance
Constructors
| MigrateSqlServerSqlDbTaskInput() |
Initializes a new instance of the MigrateSqlServerSqlDbTaskInput class. |
| MigrateSqlServerSqlDbTaskInput(SqlConnectionInfo, SqlConnectionInfo, IList<MigrateSqlServerSqlDbDatabaseInput>, MigrationValidationOptions) |
Initializes a new instance of the MigrateSqlServerSqlDbTaskInput class. |
Properties
| SelectedDatabases |
Gets or sets databases to migrate |
| SourceConnectionInfo |
Gets or sets information for connecting to source (Inherited from SqlMigrationTaskInput) |
| TargetConnectionInfo |
Gets or sets information for connecting to target (Inherited from SqlMigrationTaskInput) |
| ValidationOptions |
Gets or sets 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. |
Methods
| Validate() |
Validate the object. |