Using BulkInsert with Mirroring Replications

When replicating using mirroring mode (transactional replications) to Oracle, MySQL, SQL Server, SQL Azure and PostgreSQL targets, you can set up a  bulk insert option to enhance performance. This feature inserts blocks of records rather than single records. The size of each block can be adjusted for optimal performance. To configure bulk insert:

1. Create the target connection using the Add Target Connection  wizard in the Metadata Explorer.

2. In the Metadata Explorer, select the connection and choose Connection Properties from the right mouse button menu.

3. In the Connection Properties dialog, scroll down to the Mirroring Options section.

4. Set the Default Mirroring Insert Mode value to BulkInsert.

5. Set the Default Mirroring Block Size value to the number of rows to insert in a single operation. The value you choose depends on your environment  and you may need to adjust the value when testing replication performance.
   Note that the default setting can be overridden using the Replication Properties for a specific replication.

   NOTE: If using MYSQL Connector 8.0 or above, also set the AllowLoadLocalInfile property to True in the connection string. The default value is False, and this prevents bulk operations from succeeding.