Confluence 3.5.9 ans MS SQL 2008 transactional replication issues

Question

Is anyone out there using Transactional Replication with Confluence 3.5.9?

I'm finding issues with this, as 2 tables (cwd_application_address and hibernate_unique_key) don't have a primary key. this means I cannot use transactional replication (which would be the most appropriate for my backup database)

Has anyone resolved this issue?

Thanks

Deividi Luvison · Answer

Hey Xabier,

A pk was added to table cwd_application_address on Confluence 5 series, however the same does not apply to hibernate_unique_key unique key (still don't have a pk).

What you could do (if you hadn't done already) is to upgrade confluence to 5.0.3 (3.5.9 > 3.5.17 > 5.0.3) and then recreate your replication without targeting the hibernate_unique_key table.

Hope it helps.

Thanks and Regards,David|Confluence Support Engineer

Xabier Davila · Answer

No replies to this question so far, No one out there is using transactional replication with Confluence?