RE: [sqlite] synchronising two databases

2004-12-14 Thread Richard Boyd
om: Andrew Piskorski [mailto:[EMAIL PROTECTED] Sent: 13 December 2004 14:24 To: [EMAIL PROTECTED] Subject: Re: [sqlite] synchronising two databases On Mon, Dec 13, 2004 at 02:00:05PM -, Richard Boyd wrote: > My question is this: Is it possible for me to copy across the database file > an

Re: [sqlite] synchronising two databases

2004-12-13 Thread Andrew Piskorski
On Mon, Dec 13, 2004 at 02:00:05PM -, Richard Boyd wrote: > My question is this: Is it possible for me to copy across the database file > and then append it to the end of the locally held database thus > synchronizing the two? Is there a better way to do this synchronization? If both database

[sqlite] synchronising two databases

2004-12-13 Thread Richard Boyd
Hi all, I have an application where I need to access a database remotely (using TCP/IP). I had thought of just calling sqlite commands (possibly using RPC) and getting database data returned. However, as I will only periodically access the remote database, I need to effectively keep a copy of the