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
