Generate DDL for MySql or other databases

[steltner]

I created a data model (after I imported the MySQL-Database via ODBC). All tables are marked as MySql-tables and all datatypes are defined for MySql.

When I generate the DDL script I get a wrong syntax. For example:

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id('FK_tasks_tasklist') AND OBJECTPROPERTY(id, 'IsForeignKey') = 1)
ALTER TABLE tasks DROP CONSTRAINT FK_tasks_tasklist
;


This command doesn't work on MySql. I would like change the destination DDL language to the MySql syntax or some other databases. Where is the option in EA to change the destination DDL-syntax.

[thomaskilian]

In the Class properties for the Table there's a dropdown right in the middle.

[rneelakantan]

It looks like this syntax is for MS SQL Server and not for MySQL.  Are you sure db type is set to MySQL for the tables?

[steltner]

Yes, that's tru it looks like a script for MS SQL Server. I checked all tables and all are set to MySQL database. I have no idea where the "dbo" entry comes from.

[«Midnight»]

Just a guess. Take a look at the Settings / Database Datatypes dialog. What, if any, is the default Product Name?

[thomaskilian]

Hmm. If this influences the DDL generation then it's definitely a bug. This shall be controlled by just the table settings.

Steltner, you should submit a bug report to Sparx. They should be able to help you out or find the possible bug in EA.