Is it possible to replicate fast bcp using sql statement replication in sybase?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
No. Fast BCP is an unlogged operation. Sybase Replication Server relies on scans of the Transaction log for data to be replication. The Rep Agent thread scans the transaction log in the Primary Database (PDB) for commits. Once a committed transaction is found in the Transaction log, the SQL statements are forwarded to the Replication Server. If an action is not logged, like Fast BCP, then no entry is created in the transaction log, and therefore it can't be replicated.
Slow BCP transactions will replicate, as Slow BCP is a logged operation.
In Sybase ASE 15.7, Fast-logged BCP has been introduced, but I am not sure about whether that is supported for Replication yet.