Project Description

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/

System Requirements

execsql.py (https://pypi.org/project/execsql/)

Install

Download the release package for the DBMS you use, and place the 'xx_compare.sql' file in whatever location is convenient for it to be incorporated into SQL scripts that you write. Show How to Install

Usage

The scripts in the xx_compare.sql file for your DBMS version can either be copied and pasted into SQL scripts that you write, or the file can be included using the execsql INCLUDE metacommand. ... Show Usage

Review
Your rating
Review this project

Statistics

Recent Activities

2020-03-02
04:59
execsql-compare
04:55
execsql-compare
03:37
execsql-compare
[File Release] Package 'execsql-compare for PostgreSQL' has been deleted
Show history