Thread: sql

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    20
    Rep Power
    0

    sql


    can some one help me with sql script that will migrate data to oracle
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    60
    Rep Power
    11
    ? probalby not...

    Make it a two step process... export data from wherever it is, to a nice tab-delimited (doublequoted text fields is ok) file.

    Then there are ways to tell Oracle's imp how to suck up a nice text file and what columns in Oracle tables get what data...

    -c
  4. #3
  5. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    308
    Rep Power
    11
    Also checkout oracle migration utility.

IMN logo majestic logo threadwatch logo seochat tools logo