sbcoDefault

Use the default values for all options.

sbcoKeepIdentity

Preserve source identity values. When not specified, identity values are assigned by the destination.

sbcoCheckConstraints

Check constraints while data is being inserted. By default, constraints are not checked.

sbcoTableLock

Obtain a bulk update lock for the duration of the bulk copy operation. When not specified, row locks are used.

sbcoKeepNulls

Preserve null values in the destination table regardless of the settings for default values. When not specified, null values are replaced by default values where applicable.

sbcoFireTriggers

When specified, cause the server to fire the insert triggers for the rows being inserted into the database.

sbcoUseInternalTransaction

When specified, each batch of the bulk-copy operation will occur within a transaction. If you indicate this option and also provide a SqlTransaction object to the constructor, an ArgumentException occurs.

sbcoAllowEncryptedValueModifications

When specified, AllowEncryptedValueModifications enables bulk copying of encrypted data between tables or databases, without decrypting the data. Typically, an application would select data from encrypted columns from one table without decrypting the data (the app would connect to the database with the column encryption setting keyword set to disabled) and then would use this option to bulk insert the data, which is still encrypted. For more information, see Always Encrypted.

Use caution when specifying AllowEncryptedValueModifications as this may lead to corrupting the database because the driver does not check if the data is indeed encrypted, or if it is correctly encrypted using the same encryption type, algorithm and key as the target column.