Re: Tool to convert SQl queries to oracle or vice versa

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 18 Jan 2002 11:37:47 +0000
Message-ID: <3C48090A.73B5B8A5@exesolutions.com>

No doubt such tools exist. I would strongly urge you not to use them. The differences between SQL Server and Oracle are far greater than just syntactic. You need to learn Oracle's architecture and rewrite from scratch to avoid serializing Oracle and bringing it to its knees. If you don't ... please do not blame the Oracle product for the lack of performance and scalability of what you produce. The fault will be yours alone.

Daniel Morgan

Venky wrote:

> I am writing a VB application which has to support both SQL server or
> Oracle depending on the installation choice.
>
> I am looking for a tool which can convert SQL querieis to Oracle or
> vice versa...
>
> Any other ideas...
>
> -Venky
Received on Fri Jan 18 2002 - 05:37:47 CST