Subject | Re: [firebird-support] Creation of a "Replication Friendly" database. Any rules of thumb? |
---|---|
Author | Todd Brasseur |
Post date | 2005-03-24T15:12:17Z |
Jonathan Neve wrote:
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
>Todd Brasseur wrote:This won't be possible because the computers that need to be replicated
>
>
>
>>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.
>
>
>
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
>[Non-text portions of this message have been removed]
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>