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. E.g. sqlite-diff old.sqlite new.sqlite > patch.sql sqlite3 -batch -init patch.sql old.sqlite What I'm really looking for is the patch.sql file. I wouldn't be using sqlite3 to apply the patch (I'd apply it from within my mobile app). Cheers, Larry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users