Firebird / New database types / DDL generation

[andre.jager]

Hi,

I added a new database product (Firebird) through Settings | Database datatypes into the model. However, behaviour is totally different from the exiting database datatypes Interbase. All fields are by default "not null"and are initialzed by default to NULL. Furthermore is the generated DDL more like Oracle then like Interbase. Where do I control this? I looked around but cannot find any means of controlling the generated SQL. How do I tell EAP the Firebird DDL is more like Interbase then Oracle.

thanks,
André

[«Midnight»]

André,

There has been some discussion over the past week about how Sparx could enhance DBMS support for new engines. Unfortunately this won't help you now.

You may have to come up with a generation script on your own, or at least some kind of transformation script.

[In the latter case I don't know if how you will fare; transformation may work better if you are transforming into Interbase, rather than from Interbase to a 'new' engine. Anyone with experience in this please jump in.]

It's entirely possible that Firebird's recently updated engine will start gaining market share. Perhaps you should post in the Suggestions and Requests section of the forum and see if you get any support from other users. Sparx might be persuaded to add explicit support for data modelling and schema generation, and might even consider repository support in future.

David

[andre.jager]

David,

Thanks for the reply and the elaboration.

But could you tell me how it is implemented. Why, when I choos Firebird, does it insert extra statements into the SQL as where it doesn't when I choose Interbase.

Is this hard coded into EAP or in a template? When I look at Setting|Transformations Template|DDL I cannot find a coorelation between the generated DDL code and the database of my choosings.

thanks.

[thomaskilian]

Andre,
the DDL generation is hard coded in EA. However it is possible to create a code generation template to produce specific DDL. There has been some discussion here recently.

[Eve]

The EA help (http://www.sparxsystems.com.au/EAUserGuide/index.html?datamodelling2.htm) says to use Interbase tables for Firebird.