Create Informix To PostgreSQL DB Schema Migration Tool

For this challenge, we'd like to create a general tool that can be used to convert db schema from informix to postgreSQL.

General Requirements

Notes, ensure proper documentations for all the features.

Requirement 1: Schema Migration of Informix DB

- the schema to covert can be found on https://github.com/topcoder-platform/tc-database-scripts
- Following DB Schemas should be covered.

• common_oltp
• corporate_oltp
• informixoltp
• tcs_catalog
• time_oltp
• jive

- We have done some intitial work before see Create PostgreSQL Schema And Tool For Migrate Data From Informix Database challenge. The winning submission will be posted in forum for reference. It is not requested to code based on that, but you are free to learn the logic.
- The Tool should be able to create converted compatible DB Schema with PostgreSQL 9.6+, which can be manually executed against PostgreSQL, or automatically if the DB connection is specifie

• Important: All table/Index/trigger etc should have schema prefix, I,e DB name
  Example :
  • Create table if not exists <SchemaName>.<TableName>
  • Create table if not exists common_oltp.user
  • Create index if not exists common_oltp.<indexname>
  • Create trigger if not exists common_oltp.<trigger>
• Consider all the DB Objects Index, triggers, function, Stored procedure, synonyms etc are taken care for schema migration.
• Map right Datatype for PostgreSQL

Requirement 2: Delta Data migration and Verify for test connection for Informix  and Postgres database

Detail Requirement will be attached in forum

Requirement 3: Script for Audit

Detail Requirement will be attached in forum

Final Submission Guidelines

- DB Schema Converting Tool
- Delta Data Migration Tool
- Script For Audit
- Verification Steps