Re: DB-independent SQL

From: Tom Best <Tom.Best_at_bentley.com>
Date: Thu, 02 Dec 1999 08:41:22 -0500
Message-ID: <38467702.A57C5FE6@bentley.com>

Get a copy of the SQL-92 ANSI standard. Most major DBMSs adhere to it, but there are three levels of adherance, so read each vendors compatibility notes carefully. That takes care of the SQL syntax. Of course, you need to be sure you don't depend on any DBMS-specific environment... like triggers, or stored procedures, unless you are sure all target DBMSs have an equivalent.

Tom Best

Parker Sorenson wrote:

> Hello,
>
> Can somebody tell me what is the best way to go about writing all of
> your SQL statements so that they will be compatible with any DB server
> you use.
>
> i.e., I want to develop a DB application that is portable to different
> database systems. I do the porting of the interfaces... but, how do i
> ensure that the SQL statments plugged into those interfaces are
> "accepted" by the target DB?
>
> Is there a good resource for this somewhere?
>
> any help is very much appreciated
> -parker
Received on Thu Dec 02 1999 - 07:41:22 CST