Scripts for the execsql.py script processor that generate SQL to compare attribute values in a base table and a staging table of the same structure. SQL can be generated to produce several types of comparison results. The scripts interrogate the database's information schema to identify key and attribute columns, and therefore do not require any customization, and work with any tables in any database in any of the supported DBMSs (PostgreSQL, MariaDB/MySQL, and SQL Server).
Documentation is available at http://execsql-compare.osdn.io/
Fork