• That's a design decision that should be thought of very carefully. Rolling your own may be the way to go if you do not have time to get to understand merge replication.

    It would benefit you to take a look at it. You can control replication using the sql dmo objects (smo in 2005).

    The great thing about merge replication is it works. It has the built-in conflict resolution so you do not have to write that piece of code.