Re: Portable schema?

The best way to do this may be to use a database design program like ERStudio, ERWin or whatever they are called that supports both engines. On Mon, 06 Jul 1998 14:28:00 -0700, Roger Tomas <tomasr@agcs.com> wrote: >I'm trying to set up a schema (ie. SQL script) that I can use >with both Oracle and Informix. Constraint definitions seem >to be the where the most syntactic differences are. I've tried >to use the C preprocessor to conditionalize a lot of the code >but I've gotten to where there's more conditional code than >shared code. It's pretty ugly. > >Is this a lost cause? Does anyone know a good way to do >this? > >TIA! > >Roger Tomas >AG Communication Systems > > Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)