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 : Azure.ResourceManager.DataMigration.Models.SqlMigrationTaskInputtype MigrateSqlServerSqlDBTaskInput = class
inherit SqlMigrationTaskInputPublic Class MigrateSqlServerSqlDBTaskInput
Inherits SqlMigrationTaskInput- Inheritance
Constructors
| MigrateSqlServerSqlDBTaskInput(SqlConnectionInfo, SqlConnectionInfo, IEnumerable<MigrateSqlServerSqlDBDatabaseInput>) |
Initializes a new instance of MigrateSqlServerSqlDBTaskInput. |
Properties
| EncryptedKeyForSecureFields |
encrypted key for secure fields. |
| SelectedDatabases |
Databases to migrate. |
| SourceConnectionInfo |
Information for connecting to source. (Inherited from SqlMigrationTaskInput) |
| StartedOn |
Date and time relative to UTC when the migration was started on. |
| TargetConnectionInfo |
Information for connecting to target. (Inherited from SqlMigrationTaskInput) |
| 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. |
