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

Reply via email to