If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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

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

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...

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?"

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"...