Todd Brasseur wrote:

>We are also thinking about adding Replication. We currently have all
>primary keys as integers being created with Generators.
>
>I like the idea of the 2 part primary keys because the application is
>already quite dependent on the current primary keys (single generated
>integers) and think it would be much less work to add a second generator
>and primary key than changing existing keys to GUIIDs.
>
>

If you're making your own replicator, another solution is to have a
system for replicating the generator values. In other words, when you
replicate, you first fetch the generator value from the server, then
apply it locally, then replicate the record. That's what I did, and it
works nicely.

Regards,
Jonathan Neve.