Re: Supporting Oracle and MSSQL simultaneously

Mark Michaelis wrote:
>
> Hi,
>
> I have a software product that currently uses MSSQL Server. We are
> trying to port it to use Oracle as well. My goal is to have one
> source for both databases. The problem is I have stored procedures
> and user defined triggers. The syntax between Oracle and MSSQL stored
> procedures is significantly different as follows:
...(snipped)

This is an interesting topic that comes up time to time. If you are trying to support multiple databases you can either implement all business rules in the middle tier of a multi-tier implementation
or
maintain separate sets of codes for each target database. In first method you are not using the target database to its full capabilities,
and in the second method you spend fair amount of resources to keep the codes
in sync.
My personel preference is to maintain multiple sets of codes that take full
advantage of the target database capabilities. Hope this helps,

-- 
-M. Samson Dunatunga, Ph.D. Systems Engineering
http://www.tucson.com/objectware   e-mail: msamson@azstarnet.com
database design, reporting, query, demo tools and free software