Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Romanus on July 05, 2024, 05:56:28 pm

Title: Import DDL Script (EA build 1701 BETA)
Post by: Romanus on July 05, 2024, 05:56:28 pm

Import DDL Script (new functionality in Enterprise Architect 17) will create in the model only tables with type "table" and stereotype "PostgreSQL::table" (in my case).
PrimaryKeys and Foreign Keys are not created.
If the DDL script contains common DDL commands (COMMENT, ALTER, …), "Unexpected symbol 'COMMENT/ALTER/…'" errors are displayed, but tables not created.

Environment: EA 17.0.1701.64bit (OS Windows 11).

The issue was logged as bug report number 24077791.

Title: Re: Import DDL Script (EA build 1701 BETA)
Post by: Guillaume on July 16, 2024, 05:37:39 pm

I also get various errors from MySQL dumps, SQL Server backups, etc.
I'm waiting for the next build to run tests again. It'll be very useful when it works as users will no longer have to go through an ODBC config.

Title: Re: Import DDL Script (EA build 1701 BETA)
Post by: otiscavin on May 12, 2025, 12:30:11 pm

Quote from: Romanus on July 05, 2024, 05:56:28 pm

Import DDL Script (new functionality in Enterprise Architect 17) will create in the model only tables with type "table" and stereotype "PostgreSQL::table" (in my case).
PrimaryKeys and Foreign Keys are not created.
If the DDL script contains common DDL commands (COMMENT, ALTER, …), "Unexpected symbol 'COMMENT/ALTER/…'" errors are displayed, but tables not created.

Environment: EA 17.0.1701.64bit (OS Windows 11). Sprunki (https://incrediboxsprunki.io)

The issue was logged as bug report number 24077791.

If direct import fails, create a database using the DDL script (e.g., in MySQL, SQL Server, or Oracle), set up an ODBC connection, and use EA’s Import DB Schema from ODBC feature to bring the schema into your model.