Warren Young, on Saturday, February 9, 2019 01:36 PM, wrote... >On Feb 9, 2019, at 8:49 AM, Jose Isaias Cabrera <jic...@outlook.com> wrote: >> >> Perhaps, Dr. Hipp and the team can write a quick PRAGMA that can do >> something like this, > >You may be interested in the sqldiff program that comes with SQLite: > >$ sqldiff --help >Usage: sqldiff [options] DB1 DB2 >Output SQL text that would transform DB1 into DB2. >Options: > --changeset FILE Write a CHANGESET into FILE > -L|--lib LIBRARY Load an SQLite extension library > --primarykey Use schema-defined PRIMARY KEYs > --rbu Output SQL to create/populate RBU table(s) > --schema Show only differences in the schema > --summary Show only a summary of the differences > --table TAB Show only differences in table TAB > --transaction Show SQL output inside a transaction > >In this case, you want the --table option.
Yeah, I know about it, but I thought it was for two different DBs. Hmmm... I will check it out. Although, to check the difference on a table with a huge database with the DB1 being the same as DB2, I don't know how it will work, but, I will give it a try. Thanks. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
