Synchronize Sybase databases per transaction
Posted on 2004-10-22
I need some help with synchronizing Sybase Adaptive Server Anywhere databases. I need the databases to be synchronized on a per-transaction basis - whenever one row is modified on any database, it should initiate a synchronization of all of the other databases.
The way I see it, each sync should be of only one row (the most recently changed) and so a synchronization should not take very long.
Can someone explain how to set this whole thing up? I'm fairly new to Sybase. Are there any major problems you see arising from such a setup? How do I set it so that the sync's are automatically initiated?