Informix2postgres Migration Series: Compare Database tables and Generate Report

     Requirement

In this challenge, we would like you to compare informix and postgres  respective database/schema tables for count.

• Generate General report for each DB/schema tables. 
• Generate Table Modification report for a given parameter.
• Generate exception report, If table count mismatch.

     Specification

• Report format is shared at forums. ReportGenerationID is unique id and each time a report runs, this id has to-be mapped all DB/schema and tables. There are few tables missing on both sides hence ignore.
• For report, if either one of DB table is empty then difference is NULL.
• Write a nodejs app by connecting to respective Databases and iterate for count.
• Use ‘ifxnjs’ package for connecting to informix. Refernce implementation for infomrix can be found here https://github.com/topcoder-platform/legacy-mm-processor/

    Environment Setup

• Setup Informix Docker image 
• https://github.com/topcoder-platform/scorecard-tool
• Refer readme document, the first 2 docker command for informix docker setup.
• Setup Postgres Docker image
• https://github.com/topcoder-platform/informix-postgres-migrator/tree/master/tc-database-scripts
• Refer to readme document for postgres docker setup.

Final Submission Guidelines

• Report as per specification.
• Report generation node script.
• Clear Setup and Documentation.