One SQL code - Multiple DB vendors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: One SQL code - Multiple DB vendors

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    26

    Unhappy

    Folks:

    Does anyone have any idea as to how to implement a DB solution that can be ported across different vendors ?

    How can u write and create SQL code that can independent of the vendor specific SQL so that it can work for different DBs ?

    Any books ? Any references ?

    Thanks for the help.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Dec 2001
    Location
    Brisbane, Australia
    Posts
    28
    Our application supports multiple RDBMS (Oracle, DB2, Informix and Sybase). This is how we implement it:
    - Programmers write SQL base on an internal pre-defined SQL syntax.
    - When compiling the programs, the precompiler translates the SQL into the proper SQL statement for each RDBMS using macros. e.g. oracle.mac, db2udb.mac, sybase.mac ... etc and then compile the programs.
    The advantage of this approach is portability between RDBMS. The major drawback is the limitation of the SQL as it needs to complie with the pre-defined rules. In addition, it may not utilises all the features of each RDBMS SQL. e.g. Transat-SQL, PL/SQL ... etc.

    It really depends on what is more important and what is your primary requirement. Moreover, it needs a lot of works for the pre-defined SQL and to support the macros.

    Hope the info helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width