Re: Oracle Stored Proceedures

Richard P wrote:

> Are there any tools to convert SQL Server stored proceedures to Oracle
> --
> Direct access to this group with http://web2news.com
> http://web2news.com/?comp.databases.oracle.server

Yes and no.

Oracle offers something called the migration workbench that converts syntax. But it does not convert beyond that which means that what it produces, while likely able to compile, will be slow, inelegant, possibly corrupting, and generally of no practical use except as a starting point to recode.

The architecture and concepts behind the two products are radically different. No tool built with current technology can handle these differences. Even the so-called basics like indexes and trigger are different. Then you move to sequences vs autonumbering and the differences in transactions and locking and it becomes hopeless.

My suggestion is that you start with a copy of Tom Kyte's book "Expert one-on-one Oracle" if you can find a copy and expecially read the first three chapters. Then read the concepts and architecure docs at http://tahiti.oracle.com. Then get someone with real experience to help on the project that is willing to teach too.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)