OSDN > Finden Software > execsql-compare > Zusammenfassung

execsql-compare
Fork

Letztes Update: 2020-03-02 05:06

Projektbeschreibung
Rezensionen verfassen Web-Seite Entwickler-Dashboard

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/

Installieren

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