Subject | Replicating user data |
---|---|
Author | Grant Brown |
Post date | 2005-06-26T06:15:06Z |
Hi all,
Using Delphi 5, FIBPlus and FireBird 1.5
Never had anything to do with replication before so please bear with me.
I need to be able to allow user of our product the ability to
1) - Disconnect from the server DB (FB 1.5 in Superserver mode)
2) - Take there laptop out into the field and edit documents and or
create new ones
3) - Connect back into the server and upload new or changed documents.
So in order to do that I assume that they will need a copy of the DB on
there laptop as the embedded version and also access to the server DB
(please note that we have the server DB up and running)
So first question - How does one swap between embedded version and
server version at runtime
Next question - the big one, how does one implement replication.
What are the gotchas, for example how do we control the number
generators that create the PK numbers. Wont the get all out of wacko
TIA
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results
Using Delphi 5, FIBPlus and FireBird 1.5
Never had anything to do with replication before so please bear with me.
I need to be able to allow user of our product the ability to
1) - Disconnect from the server DB (FB 1.5 in Superserver mode)
2) - Take there laptop out into the field and edit documents and or
create new ones
3) - Connect back into the server and upload new or changed documents.
So in order to do that I assume that they will need a copy of the DB on
there laptop as the embedded version and also access to the server DB
(please note that we have the server DB up and running)
So first question - How does one swap between embedded version and
server version at runtime
Next question - the big one, how does one implement replication.
What are the gotchas, for example how do we control the number
generators that create the PK numbers. Wont the get all out of wacko
TIA
--
Regards,
Grant Brown
Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au
SiteDoc - Easy to Use - Powerful Results