> Is there a way around this? No, there's no way around this. If you want to freely create and drop tables and then propagate these changes to other database then I think the easiest way to do it for you is dump the whole database and then create second database from scratch. Or you can write some analyzer of dump's output that will find what was changed when compared to the previous dump.
Pavel On Thu, Oct 1, 2009 at 11:10 AM, Shaun Seckman (Firaxis) <shaun.seck...@firaxis.com> wrote: > I've been looking into using triggers to create a replay table. This seems > to be pretty restrictive in that it requires a trigger to be created for each > table and cannot track when tables are dropped or created (documentation says > that triggers will not be applied to tables like sqlite_master) > > Is there a way around this? > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [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 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...@sqlite.org] On Behalf Of P Kishor > 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 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 my only option seems to be utilizing some sort of library or >> application to diff the two databases and generate a SQL script based on >> the changes. >> >> > > Store the "actions made to a database," in other words, the SQL, in a > log and then replay that log against the other database. > > You can use TRIGGERs to store the SQL in a replay table. Search the > archives. Dennis Cote has contributed some code for that in one of the > threads. > > >> >> Has anyone done this before? Does such a library or application exist? >> I'm sure I could write my own if needed. >> >> >> >> -Shaun >> >> >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > Puneet Kishor http://www.punkish.org > Carbon Model http://carbonmodel.org > Charter Member, Open Source Geospatial Foundation http://www.osgeo.org > Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor > Nelson Institute, UW-Madison http://www.nelson.wisc.edu > ----------------------------------------------------------------------- > Assertions are politics; backing up assertions with evidence is science > ======================================================================= > Sent from Madison, WI, United States > _______________________________________________ > 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 > _______________________________________________ > 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
