Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Posts
    5

    Unanswered: How To Import Whole Database From Oracle To Informix

    I AM USING THE INFORMIX SE ON SUSE LINUX7.3 .

    PRESENTLY I AM HAVING DATA IN ORACLE DATABASE SERVER INSTALLED ON THE WINDOWS NT SYSTEM.

    I WANTED TO IMPORT THE WHOLE DATABASE FROM ORACLE TO INFORMIX .

    PLEASE ANY ONE KNOWS ,HELP ME

    THANKS IN ADVANCE
    SANJEEVMPATIL

  2. #2
    Join Date
    Mar 2002
    Posts
    112

    re

    In part of triggers and Tables it has 2 important thing schema+data
    if Oracle can unload data to text file then you finish 50% . Schema you can use Power Designer to reverse engineer to grap schema .
    In part of store procedure you can use power designer too

  3. #3
    Join Date
    Oct 2002
    Posts
    5
    can u tell me the steps required to do the same


    tahnks
    sanjeev

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    What dananio wanted to say is that you 'll need an ASCII dump of your database.
    Is it possible to recreate the database schema from Oracle in your informix database?
    In many cases, the application provides a tool to do these dumps. ERP systems like SAP is able to do it.
    Anyway. if you don't want to use the ASCII dump:
    Oracvle -> File
    File -> Informix
    you can use the Enterprise Gateway Manager from Infromix. This tool can connect to an Oracle database from an infromix database.
    rws

  5. #5
    Join Date
    Mar 2002
    Posts
    112

    re

    Right ,
    DBMS ---<text>------> data
    DBMS ---<sql table>--> schema
    If you can combine 2 things it's independ from DBMS
    it will have a litle problems with sql-table if you transform to SQL-standard everything will OK

Posting Permissions

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