Challenge Overview
For this challenge, we'd like to figure out the generalize way to convert the informix DB schema currently used by Topcoder internal systems to PostgreSQL DB Schema.
The main target of this challenge is to generalize the way, how can we convert the informix DB schema to PostgreSQL DB Schema.
You are expected to
1. Take common_oltp (https://github.com/topcoder-platform/tc-database-scripts) as example, and convert it into PostgreSQL DB schema.
2. For each conversion (different db statement), you are expected to describe
2.1 the database name `common_oltp` should be schema name in postgres, we are going to have a single database with different schemas to migrate.
2.2 if it is convertable, generated the converted db statement, and explain in comment, what is the rules to follow
2.3 if it is not convertable, comment out in the final script, and explain why.
2.4 Let's use default tablespace.
3. The converted DB schemas should be compatible with PostgreSQL 9.6+.
4. Create a small script to automate connection to postgres and execute the DB scripts.
5. Keep in mind, your output should be easily used as reference to convert other informix databases, like tcs_catalog else.
- Small Script to automate the execution of PostgreSQL DB script.
The main target of this challenge is to generalize the way, how can we convert the informix DB schema to PostgreSQL DB Schema.
You are expected to
1. Take common_oltp (https://github.com/topcoder-platform/tc-database-scripts) as example, and convert it into PostgreSQL DB schema.
2. For each conversion (different db statement), you are expected to describe
2.1 the database name `common_oltp` should be schema name in postgres, we are going to have a single database with different schemas to migrate.
2.2 if it is convertable, generated the converted db statement, and explain in comment, what is the rules to follow
2.3 if it is not convertable, comment out in the final script, and explain why.
2.4 Let's use default tablespace.
3. The converted DB schemas should be compatible with PostgreSQL 9.6+.
4. Create a small script to automate connection to postgres and execute the DB scripts.
5. Keep in mind, your output should be easily used as reference to convert other informix databases, like tcs_catalog else.
Final Submission Guidelines
- Generated DB Scripts, including comments for general guideline, and explaination for unconvertable pieces.- Small Script to automate the execution of PostgreSQL DB script.