Subject Re: [firebird-support] Creation of a "Replication Friendly" database. Any rules of thumb?
Author Todd Brasseur
Jonathan Neve wrote:

>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.
>
>
>
This won't be possible because the computers that need to be replicated
to the server are hand held computers. They will be used out in the
field collecting data and won't have any access to the server.

Todd

>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>



[Non-text portions of this message have been removed]