Database Column & Check Constraints

[kamiller42]

I reversed engineered a SQL 2k database and noticed none of my column and table constraints imported. (Indexes are fine.) Thinking this was just a fluke or unsupported, I created a test table with a column and table constraint and generated DDL. The DDL did not have any constraints.

How do you define column and table constraints and generate them in DDL in EA?

Also, I assume EA does not support triggers or stored procs or other db objects at this time. Correct?

[hd]

This is a bug in build 731   and has been fixed for 732.
EA does support creation of triggers and table level stored procedures. See Help | Modelling with UML | Data Modelling.

[kamiller42]

This is a bug in build 731   and has been fixed for 732.
EA does support creation of triggers and table level stored procedures. See Help | Modelling with UML | Data Modelling.

Ok. I thought that bug was just index related. Glad to see you found the problem, and it will be fixed in the next build.

FYI, I am evaluating the product now and will probably purchase pending the next build fixes things. My initial focus in using the tool is for data modeling, object modeling (not language specific), and visualing existing Delphi code. I will be testing later to see how EA handles Delphi for .NET code. Support is there?

[mikewhit]

Although EA does support indexes, triggers, stored procedures, as, effectively, an element operation, is there a way of linking (e.g.) a procedure in a table, to a diagram, to show the implementation ?

If I create an Activity diagram within the Table, then try dragging a <<proc>> into the diagram, I get a yellow activity blob with the same name - what I wanted was some way of saying "... implements ..." to show how the <<proc>> was implemented.

Or maybe that's getting too far away from 'pure' data modelling ?