Results 1 to 14 of 14
  1. #1
    Join Date
    Aug 2002
    Location
    India
    Posts
    37

    Lightbulb Unanswered: Migrating SQL Server to ORACLE

    Hello,
    I am currently working on Database migration from sql
    server 7 to oracle 8.1.7.

    My setup is as follows:

    1. Both the databases (sql server and oracle are on
    the same machine )
    2. My sql server database contains 200 tables and 190
    stored procedures, which need to be migrated to
    oracle.


    Also please suggest me the best methodology for
    Migrating the stored procedures. allmost all my stored
    procedures have TEMP Tables implemented in it. Please
    help me in this...

    Waiting for your reply,

    Thanks and Regards
    SAI SREENIVAS JEEDIGUNTA

  2. #2
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: Migrating SQL Server to ORACLE

    Originally posted by vjeedigunta

    My sql server database contains 200 tables and 190
    stored procedures

    Also please suggest me the best methodology for
    Migrating the stored procedures.
    allmost all my stored procedures have TEMP Tables implemented in it.

    No way out: you have to rewrite your stored from t-sql in pl/sql.
    I've never done this, but a firm of mine has, and he says that developing in pl/slq was a marvellous experience coming from t-sql.

    Temp tables can be a minor problem in this business:
    pl has the feature to declare tables on the fly if tables are not too fat, or you can create tables in nologging (avoiding the redo generation burden).
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  3. #3
    Join Date
    Sep 2002
    Location
    ITALY
    Posts
    53

    Re: Migrating SQL Server to ORACLE

    Originally posted by vjeedigunta

    My sql server database contains 200 tables and 190
    stored procedures

    Also please suggest me the best methodology for
    Migrating the stored procedures.
    allmost all my stored procedures have TEMP Tables implemented in it.

    No way out: you have to rewrite your stored from t-sql in pl/sql.
    I've never done this, but a firm of mine has, and he says that developing in pl/slq was a marvellous experience coming from t-sql.

    Temp tables can be a minor problem in this business:
    pl has the feature to declare tables on the fly if tables are not too fat, or you can create tables in nologging (avoiding the redo generation burden).
    Franco Ceotto
    SIPTI srl
    OnSite Services
    9i OCP DBA, Performance Engineer

  4. #4
    Join Date
    Jun 2009
    Posts
    2

    Exclamation migrate sql server 7.0 database to oracle 9

    Hello,

    I want to migrate sql server 7.0 database to oracle 9. I am really stuck, can you please help me.

    Thank you

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    We can probably help you. What problem(s) are you having?

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  6. #6
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    I've done Sybase to Oracle, it will be a lot of work. More hints, multiple RBSs, etc. create table as... varchar is varchar2 ...
    Last edited by PMASchmed; 06-18-09 at 18:30.

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by PMASchmed
    varchar is varchar2 ...
    You can use VARCHAR in Oracle without problems. It will silently be converted to a VARCHAR2

  8. #8
    Join Date
    Jun 2009
    Posts
    2
    hello,

    thanks for replying. In fact I don't have any idea of how to do it. Till now i have been migrating oracle to oracle but never sql to oracle

  9. #9
    Join Date
    Feb 2004
    Posts
    88
    have a look at this, if you really don't know where to start...although why you'd want to migrate to Oracle I have NO idea :-)

    Oracle Migration Workbench

  10. #10
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Quote Originally Posted by shammat
    You can use VARCHAR in Oracle without problems. It will silently be converted to a VARCHAR2
    I was under the impression varchar was treated as char in Oracle. Just looked, same as varchar2, but deprecated.

  11. #11
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Which system (and tool set) are you most familiar with? SQL Server, or Oracle?

  12. #12
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by thompbil
    ...although why you'd want to migrate to Oracle I have NO idea :-)
    Ditto. These days, with recent changes in Oracle's licensing structure, the trend I'm seeing is companies migrating OFF of Oracle. Not to mention the added administrative overhead. And if you are migrating, why go to 9? Why not 10?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  13. #13
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by blindman
    And if you are migrating, why go to 9? Why not 10?
    Or 11 for that matter. AFAIK 9.x is no longer officially supported (at least for "standard" customers)

  14. #14
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Here's the topper, what operating platform for Oracle? Win, AIX, HPUX ?

    If UNIX Platform, whole other ball of wax to contend with, not as friendly as Windows.

Posting Permissions

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