We are working on a project at the moment that is crying out for Notes' replication abilities. Unfortunately, the data model is very complex and would be a complete nightmare to implement in Notes. The customer wants a stand-alone system to be installed at each site and to have the databases merge at specified intervals.
Naively I had assumed there was some addon product that would allow this to happen magically (yes, OK, I was spoiled by Notes...). Truth is that even those products that do the magic (Oracle), the programmer must still ensure the keys are unique. Well duh, that's the hard part!
I am now in the process of retrofitting the application with new primary keys (SiteCode+IncrementingNumber, eg WNC199).Previously I was simply using an integer. This is a massive change to the structure.
Once the data model is updated, then I'll have to write the replication logic. I am hoping this will be quite easy and I can tackle it in a generic fashion. I am going for a hub/spoke topology with everything replicated through the head office server. The replicator will run as a seperate task as a scheduled action in a utility application.
I never did want an easy life...