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

Thread: Data Migration

  1. #1
    Join Date
    Mar 2001
    Posts
    6

    Thumbs up Migration - Need ur Views

    Hi,

    I have a typycal problem of migrating around 200 tables, views and stored procedures from DB2/400 to Oracle(8i). since Data volume is high I can'nt go for the normal approches. Looking for your suggestions for this.

    Flat file approch I need to manualy create a views & procedures. Is there any other way apart from this

    Thanks

    Arshad


    [Edited by jarshad on 03-03-2001 at 04:43 AM]

  2. #2
    Join Date
    Nov 2000
    Posts
    33
    Convert data into flat files and use SQL LODER to import the flat files into Oracle

    Anuj Pathak
    New Delhi
    6216666 ext 207

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I think that it is also possible through the oracle migration work bench. I'm not sure exactly, b'cos I haven't used it so far.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jan 2001
    Posts
    18
    Hi,

    Try a migration tool at [url]http://www.ispirer.com/chyfo.html[/url]

    It provides you the fastest, the easiest and the most powerful way to migrate your database into Oracle.
    It allows you to extract any data from any database. It works in conjunction with Oracle SQL Loader.
    The tool creates text files (moving of LOBs are fully supported), generates CREATE TABLE, CREATE INDEX scripts for Oracle and control files for SQL Loader.
    The tool has a lot of other features.

    Best regards, Dmitry.


Posting Permissions

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


Click Here to Expand Forum to Full Width