Are the databases designed to allow you to perform such an operation easily?
On the databases I do it with, I have designed in enough extra data in the db and logic in my code to handle sorting out what to do (which record to use) if both databases have different data with the same primary key. regards, Adam DeVita On Mon, Mar 10, 2014 at 8:15 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 10 Mar 2014, at 12:58pm, Muhammad Bashir Al-Noimi <mbno...@gmail.com> > wrote: > > > May I get some help from you guys? > > If you're asking how to synchronise two SQL databases which may have had > different commands executed on them, then you should know that this is an > unsolved problem which involves many difficult questions. The reason nobody > is giving you an answer is that nobody in the whole world has a good > solution which works in all cases. > > One way involves logging all the commands executed on the databases, and > playing back these commands on an unaltered copy of the database. And even > this can lead to undesired results. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
