[Sorry, i posted this in the wrong area, and I could not delete it. It does have relevance to DB2, as well as SQL Server and Oracle]
What, if any, are the differences between the structued query language used in Oracle versus SQL Server? I've read some manuals and seen reference to ANSI92 standards for both database servers. Does this mean that any SQL statement valid in SQL Server is also valid in Oracle? How about DB2?
The reason i ask:
The company I work for used MSAccess as the main database for many years. We recently saw a need to move to a database which allows for better managed transactions. We could not afford the downtime associated with a re-write of the associated code to move from Access, so we wrote a library of routines which would, based on a compile-directive (VB6) use either DAO for our existing Access customers, or an ActiveX library of emulation classes which "looked" like DAO, but used ADO behind the scenes and parsed the Access structured query language to conform to SQL Server's expectations.
This has all been done over the last year, and we actually succeeded in the zero-down-time on the code using this method. Now my curiosities are piqued and it would be excellent if all the work we put into parsing the statements was applicable to other databases (eg. Oracle, DB2, etc).