Import DDL Script (EA build 1701 BETA)

[Romanus]

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.

[Guillaume]

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.

[otiscavin]

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

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.