Re: DB Merge Replication

[mpeppler]

This is something that Sybase ASA combined with SQL Remote is really good at (which of course isn't really an answer that will be of any use to you...).

Building this sort of system in perl, and have it be reliable is likely to be a pretty serious project. I'd start with building a messaging system of some sort to push the data from the spokes to the hub. The main issue that I can see is making sure that updates are applied correctly, and that failures are detected (and retried if necessary.)

Michael

[trialmonkey]

Thanks. I haven't looked at the Sybase products in a few years. I'll revisit them.

An open source solution would be ideal. The problem with the commercial products I've used is that while they're pretty solid, they all tend to have subtle bugs. With thousands of replicating nodes a few bugs translates into lots of questions regarding the state of the data. Because they're closed source, it's often difficult to understand what's really going on and get a real solution implemented.

Building this sort of system in perl, and have it be reliable is likely to be a pretty serious project.

Hence, I'm a SoPW and looking for some stable shoulders to stand on ;-)