On 6 Mar 2012, at 1:19pm, Larry Knibb <larry.kn...@gmail.com> wrote:
> Is there already an established mechanism for diffing two SQLite > databases and creating a SQL patch file? > > So not a GUI diff tool (like > http://download.cnet.com/SQLite-Diff/3000-10254_4-205921.html) for > looking at the diffs, but something to generate the SQL to upgrade an > old database to a new one. Interesting idea. You could use the .dump command of the shell tool to create SQL dumps of each database, then diff those. I think that might be a useful start. But actually, it wouldn't be too difficult to write a program to do what you want, as long as you can make certain assumptions. For instance, that the schema aren't going to change. You could deal with indexes being created or destroyed, but it would be tricky to deal with table columns being changed. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
