> > I want to create simple program replicator
>
> Replication is anything but simple.

Indeed

I've made a 2 way replication solution see
http://pictoselector.wordpress.com/2010/11/18/designing-and-building-a-datab
ase-for-picto-selector/

For a a description of what i intended to create.

All phases are now implemented but so far synchronization has to be started
manually. I will write a separate thread in the future to do this every x
minutes in the future.

I've created a kind of log table that keeps track of inserts, deletes and
updates. All items that needs synchronization have a encoded GUIDs (22
chars) to identify (and for FK relations)

The logging was implemented in the application without the use of triggers,
but all within 1 transaction which are very short. (i do not use live
datasets)

So far the replication has worked very well. I can give more info about the
table structure if you want, but be aware that I had the luxery of defining
a new database :-)

Friendly greetings,
Martijn van der Kooij
Author of Picto Selector www.PECSforAll.com