Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is it possible to replicate fast bcp using sql statement replication in sybase?

share|improve this question
    
Don't forget to mark my answer as accepted if it was helpful. –  Michael Gardner Feb 26 '13 at 18:15

1 Answer 1

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.

share|improve this answer
    
@Gardner, I am not satisfied with the relation between SQL statement replication in Sybase and non-logged operation. As per infocenter.sybase.com, In SQL statement replication, Replication Server receives the SQL statement that modified the primary data, rather than the individual row changes from the transaction log. –  Shamika Feb 27 '13 at 16:28
    
Just expanded my answer a bit. Although you properly state how Replication works, it relies on the Transaction log, so operations that are unlogged will not replicate. –  Michael Gardner Feb 27 '13 at 17:42
    
found non-logged (select into) can be replicated in warmstandy configuration using SQL statement replication. infocenter.sybase.com/help/index.jsp?topic=/… –  Shamika Mar 6 '13 at 16:18
    
Yes, but the fact remains that BCP doesn't create a SQL statement to replicate. –  Michael Gardner Mar 6 '13 at 16:27

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.