At 07:22 AM 21-04-02 +0000, you wrote:

>I'm using Visiomodeler to generate a rather complex Firebird database. Unfo=
>
>rtunately Visiomodeler does not directly support IB/FB. But it does support =
>
>the following DBMSes and can generate SQL statements to create the DB and ta=
>
>bles in their own dialects:
>
>.IBM DB2
>.INFORMIX­Universal Server
>.INFORMIX­OnLine
>.INFORMIX­SE
>.Oracle
>.Microsoft SQL Server
>.SQLAnywhere
>.Sybase
>
>Does anyone have a suggestion which driver's SQL dialect most closely resem=
>
>bles IB/FB's? So that the generated SQL would require the least changes to p=
>
>ort to IB/FB?

Go with the Oracle one, definitely. All of the others are too
idiosyncratic...FB/IB kinda stand up there alone together as "highly
conforming".

H.


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________