Re: [sqlite] synchronizing sqlite local data base to a remote data base

2009-06-09 Thread John Stanton
I missed the mssql reference. Disregard my suggestion to copy files. You could log the SQL used to modify the DBs and pass it between DBs...Updating Sqlite would require a daemon for real time operation. Simon Slavin wrote: > On 8 Jun 2009, at 7:30pm, Mohey Eldin Hamdy wrote: > > >> I am tr

Re: [sqlite] synchronizing sqlite local data base to a remote data base

2009-06-09 Thread John Stanton
An SQL database is just a file. A copy will sync it, and so will a process like rsync. Real time synchronization requires that you implement some form of daemon. Mohey Eldin Hamdy wrote: > Hey got a question, > > I am trying to synchronize an sqlite local data base with a remote mssql > data ba

Re: [sqlite] synchronizing sqlite local data base to a remote data base

2009-06-08 Thread Vladimir Kharitonov
You can use Microsoft Sync Framework if your platform is Microsoft Windows. 2009/6/8 Mohey Eldin Hamdy > Hey got a question, > > I am trying to synchronize an sqlite local data base with a remote mssql > data base. I wasn't able to find any listed function at > http://www.sqlite.org/c3ref/funcli

Re: [sqlite] synchronizing sqlite local data base to a remote data base

2009-06-08 Thread Martin Engelschalk
Hi, What Simon is right. When solving a similar problem in the past I created special tables in both databases which i filled from triggers on the data tables. These tables contained the changed data which i then could reproduce on the other database using a special deamon process. However, my

Re: [sqlite] synchronizing sqlite local data base to a remote data base

2009-06-08 Thread Simon Slavin
On 8 Jun 2009, at 7:30pm, Mohey Eldin Hamdy wrote: > I am trying to synchronize an sqlite local data base with a remote > mssql > data base. I wasn't able to find any listed function at > http://www.sqlite.org/c3ref/funclist.html to do something like that. > Any > ideas please. The sqlite3