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
