DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: INGRES TO ORACLE

  1. 02-14-2001, 04:40 PM #1
    sree_sri
    sree_sri is offline Member
    Join Date
    Feb 2001
    Posts
    203
    Hi Folks,
    I need to convert some data from INGRES to ORACLE. Is there any tool for that.
    sree
    Reply With Quote Reply With Quote
  2. 02-14-2001, 04:42 PM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    only data or whole database structure+constraints+indexes
    Reply With Quote Reply With Quote
  3. 02-14-2001, 04:47 PM #3
    sree_sri
    sree_sri is offline Member
    Join Date
    Feb 2001
    Posts
    203
    Pando,

    All ready we have database in oracle. Now some other dept people wants to use the same application. I created a new database for them but now they are asking me to migrate data from INGRES to ORACLE. I asked them to send data in text files, After that i will load the data in temp tables and i will do some modifications to that data and i will load that data into production tables. Do you know any tools to help this process?
    sree
    Reply With Quote Reply With Quote
  4. 02-14-2001, 05:04 PM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    reverse engineering the data model in ingress (with ER Studio by Embarcadero and with ODBC if ingress supports ODBC?), generate a Oracle SQL script to create the tables, ER Studio will generate script to create the tables, indexes, and constraints.

    Get the data in plain txt file and load it to the tables
    with SQL*Loader
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width