Synchronising dbs from several servers

[Florian Bogeschdorfer]

Thank you Cindy, that is another way yes. It is less performant, but this
would mean only slight changes to my coding.
I am planning on adding a "changed" flag now to all tables, and a script
that will look for the changed records in the relevant tables every few
seconds and synchronize them. 

Best regards, Florian

PS: Ruslan, there is no automatic timestamp of last record change?

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Cindy Brown
> Sent: Thursday, October 28, 2004 8:11 PM
> To: Valentina Developers
> Subject: Re: Synchronising dbs from several servers
> 
> Hi,
> 
> I do this at the moment but with TCP/IP across a LAN. What I 
> did was set up an additional baseobject which is unique to 
> each machine and keeps track of all changes. This database in 
> that baseobject has four fields - the name of the database 
> where the change occurred, a unique recid for the record that 
> has been changed, the type of change (add, edit, delete) and 
> lastly the name of the machine (or in your case server) where 
> the change was made.
> 
> I then use a timer to check every 30 seconds (you could make 
> it quicker) whether there have been any changes on the 
> workstation. If there are any new additions to the sync list, 
> these changes are sent across to a main server and added to 
> the main server's sync list. Then if there are any changes on 
> the main server, these are sent back to the workstation.
> 
> It took a bit of work to get this to go right but I have 
> managed it with REALbasic and Valentina 1.10. I now have it 
> working with up to 50 machines on a network talking to a 
> server and syncing whenever they connect.
> 
> Hope that helps.
> 
> Cindy 
> 
> >> Each outlet can be a publisher, eg customer goes to outlet 
> 10, buys 
> >> something, then 15 minutes later he goes to outlet 15 and 
> there must 
> >> be the changes already downloaded...
> >
> --
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina