Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Unanswered: Porting data from SQL Server to Oracle over ODBC

    Hi everyone,

    I have an ODBC question. I have two databases on the network. One is running under SQL Server and the other is running under Oracle. There is a schema on the Oracle database that has the exact schema as the SQL Server database (more or less). What I want to do is copy the contents of each table from SQL Server to Oracle. I know there must be a way to do this with a view or a script. I cannot use any tool like Oracle migration or anything else and it has to go over ODBC.

    Can someone suggest a way to do this? Could Access be used for something like this? I am afraid I am extremely inexperienced with database stuff.

    Thanks. Any help would be greatly appreciated.

    Sincerely,

    Pankaj

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    It appears to me that you have a solution (ODBC) insearch of problem.

    I'd use PERL's DBD/DBI to move the data between SQL Server & Oracle
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Talking

    Yeah, you got that right. I have the solution, I just did not know how to implement it

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I just did not know how to implement it
    This sad reality means ODBC is somewhat lacking as your 'solution'.

    A shovel is a great tool for making a hole in the ground,
    but only when the "correct end" comes into contact with the Earth.

    One might conclude that you are using the "wrong end" of the computer.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Duh!

    Hi,

    I did not get any sleep last night. Of course the obvious answer was the DTS wizard built into SQL Server!

    Thanks,
    Pankaj

Posting Permissions

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