当前位置: 动力学知识库 > 问答 > 编程问答 >

Converting Informix schema to PostgreSQL schema

问题描述:

How can I convert INFORMIX-SQL Version 11.50.FC3 schema to PostgreSQL 9.2 schema?

网友答案:

I did some conversions as Craig said:

  1. dbexport of Informix database
  2. some search & replace in schema text file (I use Python for such things).
  3. on PostgreSQL server: psql -f [schema_file] new_database
  4. analyze psql output and if something is wrong drop new PostgreSQL database, and correct search & replace tools (goto 2)

When you convert all interesting things into PostgreSQL you can compare both schemas using my tools like: http://code.activestate.com/recipes/576621-dump-informix-schema-to-text/

Those tools are used mainly to compare Informix vs other Informix or PostgreSQL vs other PostgreSQL database but after some normalizing I believe you can compare PostgreSQL vs Informix.

分享给朋友:
您可能感兴趣的文章:
随机阅读: