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

Very true. I consulted for a company last year porting their CRP system from SQL Server to Oracle and trying to maintain a single source code. They quickly learned that it is just a great way to write bad software on two systems.

Daniel Morgan

Niall Litchfield wrote:

> "Chris" <christianboivin1_at_hotmail.com> wrote in message
> news:da20daf0.0201221334.62e05946_at_posting.google.com...
> > Hi
> >
> > If you can, just write standard ansi92 SQL queries
> > because its understand by both DB
>
> The first trouble with this is that it isn't really true. Of course both
> products support base level SQL92 - but that is all you can really rely on.
> As far as I can tell the ANSI Join syntax for example is LEFT [OUTER] JOIN
> ON. Oracle before 9i will not recognize this syntax. SQL server will.
>
> The second trouble of course is that you are denying yourself features and
> performance at the ,dubious, benefit of portability.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
Received on Wed Jan 23 2002 - 03:43:31 CST