Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2003
    Posts
    17

    Question Unanswered: Exporting databases with Ingres 6.4 ?

    Hi everybody,

    I need to transfer some Ingres 6.4/06 databases from an old HP9000 box to a new IBM pSeries system running Oracle 9i. Is there any utilities within Ingres that would export databases to a specific filetype? I could then use Oracle SQL*Loader to import the data.

    Ideas are welcome,

    Thanks in advance!

    Steve

  2. #2
    Join Date
    Jun 2003
    Location
    Hamburg, Germany
    Posts
    38
    Hi,

    Do you mean export as comma (or other delimiter) delimited file?

    Take a look at the copydb command. I cannot remember exact syntax. I'm pretty sure you can modify the sql scripts created if you need to set a specific delimiter. Check also the issue with exported data files > 2GB.

  3. #3
    Join Date
    Jun 2003
    Location
    Hamburg, Germany
    Posts
    38
    Hi...

    Try looking also at the unloaddb command. This is a 2 stage. First it creates unload scripts and then you can export data. Updating the script files may do what you need.

  4. #4
    Join Date
    Feb 2003
    Posts
    17
    Yes, I need to export them as comma delimited ascii files.

    I have another concern. It seems that the command will only take the actual USER's tables, not ALL tables. It would be crazy to login again with every other username to get all tables! Is there any way to get over this?

    Thank you very much for your help!

    Steve

  5. #5
    Join Date
    Feb 2003
    Posts
    17
    ... unloaddb and copydb seems to only create the DDL, it won't create ascii files with every record in it. That's what I need. Also, the DDL files syntax won't be recognized by Oracle and it would be too long to change the file manually (the script is very big). Am I right to say that the only clean way would be to use a third-party utility? If so, which one would do the job?

    Thanks again,

    Steve

  6. #6
    Join Date
    Jun 2003
    Location
    Hamburg, Germany
    Posts
    38
    You have to run the scripts created to get the data to unload. It's a 2-stage process. The utils create the SQL to export, you then run the SQL created to extract the data. You then need a util to create the tables in Oracle and load the data from the flat-files you just created.
    Maybe there is a 3rd party util (or maybe one from Oracle) to make the loading/conversion easier.

  7. #7
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    You need to run unloaddb as the database owner (usually ingres). This will create an unload.ing which will export the data for when you run it. It will export all tables for all users if you run as datbase owner.

    There will be a copy.out and copy.in created - if you wish to change the format of the output (ie commas or tab seperated etc..) then edit the copy.out using sed or awk (the file is normally quite big!) to the format of your choice.
    Regards
    Dbabren

Posting Permissions

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