Migrate from Informix to Postgres & Build Docker.

1.Informix Files Scope of Migration

       a. https://github.com/topcoder-platform/tc-database-scripts/tree/master/time_oltp
             Convert all 5 files to postgres.
       b.  https://github.com/topcoder-platform/tc-database-scripts/tree/master/corporate_oltp
             Out of 4 files, just ignore 04_corporate_oltp_synonyms_procedures_and_triggers.sql file and convert remaining 3 files to postgres.

2.Docker scope. 

1. Create a Dockerfile or Docker-compose which automatically deploys following schemas during docker run.
2. Scope includes,
   1. The following 4 schemas  which is already converted and link is shared (jive/common_oltp/tcs_catalog/Informixoltp) https://github.com/topcoder-platform/informix-postgres-migrator/tree/master/tc-database-scripts
   2. And 2 schemas (time_oltp/corporate_oltp) from 1^st requirement above

3. Requirement Consideration :

• The target postgres version is 9.6
• Scope includes  Schema, Data, Index, Stored procedure, functions, synonyms and triggers conversion and Postgres doesn’t support synonyms hence use views
• You can automate it or manually do it but ensure that there is no mismatch/issues in data or datatype. Ensure that you map appropriate datatype, size
• Informix procedure convert to postgres function, refer already converted one herehttps://github.com/topcoder-platform/informix-postgres-migrator/blob/master/tc-database-scripts/corporate_oltp/04_corporate_oltp_synonyms_procedures_and_triggers.sql
• Although postgres 11 onwards support stored procedure, we don’t want this approach
• Corporate_oltp and time_oltp DB are small DBs compared to earlier converted ones

Final Submission Guidelines

Verification.

• Run the docker and verify all 6 DB schemas are executed successfully and able to access respective schemas in postgres.
• Ensure converted schema has right datatype.

Final Submission Guidelines

• Converted PostgreSQL schema.
• Dockerfile/Docker-compose.
• Documentation.