Change Log

Version Date Features
2.0.0 2019-05-23 Added the UPDTPK_ONE script to update primary keys in a single table.
1.4.2 2019-05-01 Corrected use of ‘trim()’ in ss_upsert.sql.
1.4.1 2019-03-24 Modified MariaDB script to restrict data pulled from the information_schema for primary key checks to the current database.
1.4.0 2019-03-13 Added checks for valid schema and table names.
1.3.1 2019-03-14 Correction to staged_to_load() for Postgres.
1.3.0 2019-03-09 Added checks for duplicate primary keys in staging tables, and other improvements.
1.2.0 2019-03-07 Added version for SQL Server in ss_upsert.sql.
1.1.0 2019-03-03 Added the ‘do_commit’ argument to the ‘load_staging’ script.
1.0.3 2019-03-02 Protected foreign-key ordering against multi-table cycles.
1.0.2 2019-02-28 Modified script for Postgres to get foreign key information from catalog tables instead of information schema to allow for duplicate FK constraint names in different tables.
1.0.1 2019-02-21 Modified scripts for Postgres and MariaDB to use local variables for error message return values.
1.0.0 2019-02-16 Complete initial versions for PostgreSQL and MariaDB/MySQL.