DSI Bulk Copy-in

Replication Server supports bulk-copy-in, which improves performance when replicating large batches of insert statements on the same table in the replicate database.

In normal replication, when replicating to a replicate database, Replication Server forms a SQL insert command, sends the command to the replicate database, and waits for the replicate database to process the row and send back the result of the operation. This affects Replication Server performance when large batches of data are being replicated, such as in end-of-day batch processing or trade consolidation.

Database Support

Bulk-copy-in is supported for Adaptive Server databases, and Oracle replicate databases that are updated by ExpressConnect for Oracle. If you turn on DSI bulk copy-in and the replicate database is not supported, DSI shuts down with an error. See Replication Server Options > ExpressConnect for Oracle Installation and Configuration Guide > System Requirements.