Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: beaugeek on April 17, 2006, 06:26:33 pm

Title: Firebird data modeling
Post by: beaugeek on April 17, 2006, 06:26:33 pm

I'm trying to use EA to construct a data model for a Firebird database.  If I understand correctly, support for Firebird 1.5 was added in build 748.  But when I create a table based on the Interbase driver, of course I don't see a few Firebird datatypes (date, time, etc).

I tried creating a new custom database for Firebird, but the DDL generated through that database driver wasn't in proper Firebird syntax.

I'm absolutely new to EA, so perhaps I'm missing something obvious here.  Should I try adding the additional Firebird datatypes to the Interbase definition, and use that?  Or, is there a way to shape the DDL that comes out of EA for a specific custom database?  I imagine the latter is hard to do.

Any help and hints would be much appreciated.  Thanks.

 -- Vikram

Title: Re: Firebird data modeling
Post by: beaugeek on April 19, 2006, 06:04:51 pm

No answers...  Hmmmm...  Does that mean, "EA can't produce Firebird DDL," or does it mean, "You asked a really dumb question, RTFM"?

Wonderingly,

  Vikram

Title: Re: Firebird data modeling
Post by: Eve on April 19, 2006, 06:31:21 pm

Well, the help file only seems to say that it can be done and to use Interbase tables.

However, from that I would conclude that you should add the Firebird types to the interbase definition.  Creating a new database for Firebird would mean that it is no longer using Interbase tables.