Printable View
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
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!
Hi
You can use Orace migration workbench to migrate from sybase to Oracle
Regards
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... :D. And is a great technology. I'm sincerely sorry for you...
At least if you were taking to Oracle 9i, that is more supportable...
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?"Quote:
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!
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"... :D
[Edited by ovidius on 04-12-2002 at 05:19 AM]