-
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... . 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!
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|