[sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
Hello, I'm looking to externally track the actions made to a database so that I can apply those same actions to another database (assuming the other database has a similar schema). I've searched the documentation and there doesn't seem to be an easy way to extract this data so

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Adam DeVita
There has been a lot of discussion of this and several of us are doing it. Are you talking about A) DB1 which has modify data and DB2 which only receives modifications from DB1 only, or B) DB1 and DB2 both get updates independently and need to be synchronized? or C) something else Not (A or

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread P Kishor
On Thu, Oct 1, 2009 at 8:44 AM, Shaun Seckman (Firaxis) shaun.seck...@firaxis.com wrote: Hello,                I'm looking to externally track the actions made to a database so that I can apply those same actions to another database (assuming the other database has a similar schema).   I've

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Adam DeVita Sent: Thursday, October 01, 2009 9:49 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database Diff libs or applications There has been a lot

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
Sent: Thursday, October 01, 2009 10:03 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database Diff libs or applications On Thu, Oct 1, 2009 at 8:44 AM, Shaun Seckman (Firaxis) shaun.seck...@firaxis.com wrote: Hello,                I'm looking to externally track the actions

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Shaun Seckman (Firaxis)
: [sqlite] Database Diff libs or applications Are there any limitations to this? Will this track any and all SQL actions done to the database or just table data changes? I'll hunt down the post now :) -Shaun -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Pavel Ivanov
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman (Firaxis) Sent: Thursday, October 01, 2009 10:13 AM To: punk...@eidesis.org; General Discussion of SQLite Database Subject: Re: [sqlite] Database Diff libs or applications Are there any limitations to this?  Will this track any

Re: [sqlite] Database Diff libs or applications

2009-10-01 Thread Douglas E. Fajardo
...@sqlite.org] On Behalf Of Shaun Seckman (Firaxis) Sent: Thursday, October 01, 2009 8:10 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database Diff libs or applications I've been looking into using triggers to create a replay table. This seems to be pretty restrictive