Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2003
    Posts
    4

    Cool Unanswered: Informix to Postgres

    HI,

    I need a program / tool to convert an informix database to Postgres.
    Can anybody help me?

    thx

  2. #2
    Join Date
    Jul 2003
    Location
    Portugal (EU)
    Posts
    6

    Smile Re: Informix to Postgres

    Originally posted by goldman82
    HI,

    I need a program / tool to convert an informix database to Postgres.
    Can anybody help me?

    thx
    What version/operating system are you running Informix and PostgreSQL on?

    I don't know of any specific tool to do such a conversion, I would expect you will have to export the data from informix with the command 'dbexport <database_name_here>' which will generate a 'tar' file containing separate text files containing the SQL data about *each* Informix table.

    You can then convert manually each SQL file to Postgresql data types and then import these changed files into PostgreSQL. This is exactly what I am doing, and I expect it to take more than a week to process fully. Of course it depends a lot on the complexity of the database(s) you are converting. And if the database uses specific features of Informix that PostgreSQL does not have (I don't know it there are any, but I'd expect that there are a few) then it may take a bit of database re-engineering.

    It can always be done, just not by someone without a *lot* of patience and time.

    If your Informix installation has an ODBC driver, I'd recommend you try to copy all data you need into an Access database, and later transfer that into Postgresql through ODBC also.

    Hope this helps...
    Last edited by legolas; 07-31-03 at 09:48.

  3. #3
    Join Date
    Jul 2003
    Posts
    4

    Talking

    thanks :-)))

    PS: both databases are running on Linux SuSe

    I found only a tool to import an Oracle Database into PostgreSQL...

  4. #4
    Join Date
    Apr 2003
    Location
    Tunisia
    Posts
    192

    Thumbs up We have done this !

    We have made a massive migration from Informix from Postgres, the method we used was :

    - Dumping the base into text files with ; as delmimiation caracter (u could choose any caracter).

    - We used http://www.dbtools.com.br (under windows) that imports a datacase from text delimited files.

    Easy as hello , u can do the same thing in a linux shel with just some sed or awk knolege.
    Open up
    Take a look to my Blog http://www.rundom.com/karim2k

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •