Share via


MigrateSqlServerSqlDBTaskInput Class

Definition

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

public class MigrateSqlServerSqlDBTaskInput : Azure.ResourceManager.DataMigration.Models.SqlMigrationTaskInput, System.ClientModel.Primitives.IJsonModel<Azure.ResourceManager.DataMigration.Models.MigrateSqlServerSqlDBTaskInput>, System.ClientModel.Primitives.IPersistableModel<Azure.ResourceManager.DataMigration.Models.MigrateSqlServerSqlDBTaskInput>
type MigrateSqlServerSqlDBTaskInput = class
    inherit SqlMigrationTaskInput
    interface IJsonModel<MigrateSqlServerSqlDBTaskInput>
    interface IPersistableModel<MigrateSqlServerSqlDBTaskInput>
Public Class MigrateSqlServerSqlDBTaskInput
Inherits SqlMigrationTaskInput
Implements IJsonModel(Of MigrateSqlServerSqlDBTaskInput), IPersistableModel(Of MigrateSqlServerSqlDBTaskInput)
Inheritance
MigrateSqlServerSqlDBTaskInput
Implements

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.

Methods

JsonModelWriteCore(Utf8JsonWriter, ModelReaderWriterOptions)

Explicit Interface Implementations

IJsonModel<MigrateSqlServerSqlDBTaskInput>.Create(Utf8JsonReader, ModelReaderWriterOptions)

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

IJsonModel<MigrateSqlServerSqlDBTaskInput>.Write(Utf8JsonWriter, ModelReaderWriterOptions)

Writes the model to the provided Utf8JsonWriter.

IJsonModel<SqlMigrationTaskInput>.Create(Utf8JsonReader, ModelReaderWriterOptions)

Reads one JSON value (including objects or arrays) from the provided reader and converts it to a model.

(Inherited from SqlMigrationTaskInput)
IJsonModel<SqlMigrationTaskInput>.Write(Utf8JsonWriter, ModelReaderWriterOptions)

Writes the model to the provided Utf8JsonWriter.

(Inherited from SqlMigrationTaskInput)
IPersistableModel<MigrateSqlServerSqlDBTaskInput>.Create(BinaryData, ModelReaderWriterOptions)

Converts the provided BinaryData into a model.

IPersistableModel<MigrateSqlServerSqlDBTaskInput>.GetFormatFromOptions(ModelReaderWriterOptions)

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

IPersistableModel<MigrateSqlServerSqlDBTaskInput>.Write(ModelReaderWriterOptions)

Writes the model into a BinaryData.

IPersistableModel<SqlMigrationTaskInput>.Create(BinaryData, ModelReaderWriterOptions)

Converts the provided BinaryData into a model.

(Inherited from SqlMigrationTaskInput)
IPersistableModel<SqlMigrationTaskInput>.GetFormatFromOptions(ModelReaderWriterOptions)

Gets the data interchange format (JSON, Xml, etc) that the model uses when communicating with the service.

(Inherited from SqlMigrationTaskInput)
IPersistableModel<SqlMigrationTaskInput>.Write(ModelReaderWriterOptions)

Writes the model into a BinaryData.

(Inherited from SqlMigrationTaskInput)

Applies to