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

Thread: CONV FROM SYBASE TO ORACLE

  1. #1
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    Objective - conversion from sybase database to oracle database.

    sybase database version 11.5
    oracle version 8.1.7

    sybase sql to oracle sql /plsql
    sybase tables, views to oracle tables , views
    some stored procedures to be converted to oracle proc.

    1 is there ay tool in oracle which can do these conversions.
    2 any one who has done this can u please tell me how did u
    do this
    3 if not 1 or 2 then any link /web site where i can get the
    conversion procedures

    Thanks in advance
    Pravin






  2. #2
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    I have done this but I'm sorry friend, we had to rewrite all the transact sql into PL/SQL. The benefit here is that you learn PL/SQL really well.

    Do experiments with the Oracle vs. Sybase:
    1. The handling of nulls - results in expressions
    2. The conversion of DDL is much easier than the code is.

    If I think of anything else, I'll let you know BUT WE DID IT SUCCESSFULLY in a data warehouse environment, no less, where the business logic was really intense. I like PL/SQL much more than Transact SQL

    Good Luck!

  3. #3
    Join Date
    Mar 2001
    Posts
    635
    Hi

    You can use Orace migration workbench to migrate from sybase to Oracle

    Regards

  4. #4

    Talking

    But, if you have a very large database and you are not feeling like writting lots of boring ddl conversions, you know very well you can use Sybase PowerDesigner (at least app. modeller) for converting a model that you can obtain by reverse engeneering. If you do not have it, yet...
    BTW, aren't you sorry for such a waste? Sybase ASE is a server on wich 95% of Wall Street is based... . And is a great technology. I'm sincerely sorry for you...
    At least if you were taking to Oracle 9i, that is more supportable...
    ovidius over!

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by gopi
    I have done this but I'm sorry friend, we had to rewrite all the transact sql into PL/SQL. The benefit here is that you learn PL/SQL really well.

    Do experiments with the Oracle vs. Sybase:
    1. The handling of nulls - results in expressions
    2. The conversion of DDL is much easier than the code is.

    If I think of anything else, I'll let you know BUT WE DID IT SUCCESSFULLY in a data warehouse environment, no less, where the business logic was really intense. I like PL/SQL much more than Transact SQL

    Good Luck!
    If I ask you to tell me with what is Sybase inferior to Oracle, how would you respond? Or like that: "Why should I chose Oracle instead of Sybase?"


    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  6. #6
    Usually, the answer is "because this is the company policy" or "because this is the new company policy"...
    Sybase technology is not inferior to Oracle. And I do not think Oracle has something to compete with Sybase IQ, for instance.
    There are lots of technologies, and every single one has its pros/cons. But I think Sybase cons are not technical, but of other kind, usually. Oh, do not understand me wrong. I do not think Sybase is the best technology in the world ... simply because there is not such a think. There are only "the best suitable technology for my business"...

    [Edited by ovidius on 04-12-2002 at 05:19 AM]
    ovidius over!

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