The tables are very simple. They have a primary key, but no relationship between tables in the sense that you mean. Synchronisation will be add new rows, and update some rows, no deletions
On 13 August 2015 at 05:53, Simon Slavin <slavins at bigfraud.org> wrote: > > On 13 Aug 2015, at 3:52am, Chris Parsonson <z2668856 at gmail.com> wrote: > > > I need to be able to synchronise some fairly simple table in two > databases. > > Are both copies of a table being changed between synchronisations ? Are > the changes just the adding of new rows, or do you sometimes delete or > update rows ? > > Is the database schema relational ? In other words, do you have a column > of one table as the primary key of another table ? > > If the answer to all the above questions is 'yes' then it is very > difficult to synchronise two copies of one database. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Chris Parsonson 083 777 9261
