Challenge Overview
For this challenge, we'd like to migrate the forums related tables to PostgreSQL database, and creating migration tool to migrate the data in informix tables to PostgreSQL.
General Requirements
1. Create PostgreSQL Schema, that will replicate the similar schema in informix, see https://github.com/topcoder-platform/tc-database-scripts/tree/dev/jive
2. Create Migration Tool that can be easily migrate the existing data from Informix to PostgreSQL, prefer to use Node.js or Java, but not limited for that, since the functionlity remains.
2.1 the configuration for Informix and PostgreSQL databases should be easily adjust.
2.2 the tool should be run multiple times without problems, like initial running for migrating to empty PostgreSQL table, second running to sync the unmigriated data from informix to PostgreSQL when we have done the cutover to using PostgreSQL.
- Source Code For Migration Tool
- Setup and Verification Steps
General Requirements
1. Create PostgreSQL Schema, that will replicate the similar schema in informix, see https://github.com/topcoder-platform/tc-database-scripts/tree/dev/jive
2. Create Migration Tool that can be easily migrate the existing data from Informix to PostgreSQL, prefer to use Node.js or Java, but not limited for that, since the functionlity remains.
2.1 the configuration for Informix and PostgreSQL databases should be easily adjust.
2.2 the tool should be run multiple times without problems, like initial running for migrating to empty PostgreSQL table, second running to sync the unmigriated data from informix to PostgreSQL when we have done the cutover to using PostgreSQL.
Final Submission Guidelines
- PostgreSQL schema to initialize the database- Source Code For Migration Tool
- Setup and Verification Steps