项目描述

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/

安装

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

用法

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

Your rating
Review this project

统计

近期活动

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