Re: URGENT Can you convert SQL Stored Proceedures to Oracle?

On Sun, 25 May 2003, damorgan_at_exxesolutions.com wrote:

> Advice to Mladen, Galen, and others. Get a copy of Tom Kyte's book
> "Expert one-on-one Oracle." Tom provides ample examples of the
> disaster that can await those that migrate from SQL Server to Oracle,
> and visa versa, without a proper understanding of the architectural
> differences.

Advice to Daniel. Get Blow Hard's one-on-one Bully Pulpit. There, you will acquire quotes which will allow you to recite things written by someone else so often that they become your own original thoughts.

I have Tom's book. It is quite good. For migration projects, it helps you identify pitfalls. It doesn't state, don't migrate. It says be aware of the differences, be ready for Oracle to look worse and behave differently than SQLServer and others. It doesn't state, don't migrate. It also doesn't state, don't use Oracle Migration Workbench. This is a useful tool to help someone get to Oracle. If you truly think that all of production SQLServer stored procs's working code should just be scrapped and completely rewritten and rearchitected, I think you need to buy someone else's book, I'm just not sure who's book that is.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.