Thanks, I'll look into something like that. I think there must be a neat way of doing this synchronisation besides actually copying files, but this method should get me started.
I'll keep you posted if I come up with any other method. Regards, Richard. -----Original Message----- From: 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 -0000, 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 databases are shut down, presumably you could use rsync to blindly synchronize the two at the binary level. Conceivably you could even integrate something like librsync into SQLite and thus do the rsync operation while the database is locked, with no other activity going on. http://librsync.sourceforge.net/ (This is all speculation on my part though, I have tried nothing of the sort. And of course, there might already be some better way to do it in SQLite.) -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.801 / Virus Database: 544 - Release Date: 24/11/04 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.813 / Virus Database: 553 - Release Date: 13/12/04