Dela via


SqlMISink Class

Definition

A copy activity Azure SQL Managed Instance sink.

public class SqlMISink : Microsoft.Azure.Management.DataFactory.Models.CopySink
type SqlMISink = class
    inherit CopySink
Public Class SqlMISink
Inherits CopySink
Inheritance
SqlMISink

Constructors

SqlMISink()

Initializes a new instance of the SqlMISink class.

SqlMISink(IDictionary<String,Object>, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, Object, SqlUpsertSettings)

Initializes a new instance of the SqlMISink class.

Properties

AdditionalProperties

Gets or sets unmatched properties from the message are deserialized this collection

(Inherited from CopySink)
DisableMetricsCollection

Gets or sets if true, disable data store metrics collection. Default is false. Type: boolean (or Expression with resultType boolean).

(Inherited from CopySink)
MaxConcurrentConnections

Gets or sets the maximum concurrent connection count for the sink data store. Type: integer (or Expression with resultType integer).

(Inherited from CopySink)
PreCopyScript

Gets or sets SQL pre-copy script. Type: string (or Expression with resultType string).

SinkRetryCount

Gets or sets sink retry count. Type: integer (or Expression with resultType integer).

(Inherited from CopySink)
SinkRetryWait

Gets or sets sink retry wait. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

(Inherited from CopySink)
SqlWriterStoredProcedureName

Gets or sets SQL writer stored procedure name. Type: string (or Expression with resultType string).

SqlWriterTableType

Gets or sets SQL writer table type. Type: string (or Expression with resultType string).

SqlWriterUseTableLock

Gets or sets whether to use table lock during bulk copy. Type: boolean (or Expression with resultType boolean).

StoredProcedureParameters

Gets or sets SQL stored procedure parameters.

StoredProcedureTableTypeParameterName

Gets or sets the stored procedure parameter name of the table type. Type: string (or Expression with resultType string).

TableOption

Gets or sets the option to handle sink table, such as autoCreate. For now only 'autoCreate' value is supported. Type: string (or Expression with resultType string).

UpsertSettings

Gets or sets SQL upsert settings.

WriteBatchSize

Gets or sets write batch size. Type: integer (or Expression with resultType integer), minimum: 0.

(Inherited from CopySink)
WriteBatchTimeout

Gets or sets write batch timeout. Type: string (or Expression with resultType string), pattern: ((\d+).)?(\d\d):(60|([0-5][0-9])):(60|([0-5][0-9])).

(Inherited from CopySink)
WriteBehavior

Gets or sets white behavior when copying data into azure SQL MI. Type: SqlWriteBehaviorEnum (or Expression with resultType SqlWriteBehaviorEnum)

Applies to