Databases

[ronnie]

Been working through a database model and have found a few additions/queries (no pun intended) that I thought I'd throw into the melting pot...

1. Option to place [] (or another option maybe) around identifiers to avoid conflict with reserved-words.

2. What happens to the data-types if you switch database? Is this where the 'Common Type' field comes in?

3. There doesn't seem to be much configuration in the options regarding DB's compared to other code generating. Also the 'Default DB' is a text box, shouldn't this be a List-Box from the configured DB's?

4. Is there a way (and if not could there be) to hide role names in associations? EG. If you didn't want to see the names of the PK and FK on the link?

5. Indexes don't seem to be imported or generated. I created an operation stereotyped as an index and attached a column, but no DDL generated to create the index. Also, when importing a table through ODBC from MSSQL7 that had an index there was no operation created - ?

Thanks guys,
Ronnie

[sparks]

Hello,

1.  I have made a note of this and the next time we make changes to EA in this area, we will include an option to do this.

2. If you switch databases the columns will retain their existing datatypes, however these maybe invalid in the new database and the invalid one will need to be manually corrected.  

3. Over time we have added more options to the DDL generation screen, however what in particular do you find missing?  Originally a textbox was choosen so that a user could enter any database name, not just the ones that have datatypes defined.  However this could be changd to a combobox that allows the user to type their own value.

4. Currently there is no way to achieve this, however we see what can be added to a future version.

5. Yes that is right, current the import and generation of indexes, stored procedures and triggers are not support by EA.  However these features are on our list to add into EA in the future.  At this stage there is no fixed release date, but we would hope that they would be included in the next few months.

Paul Mathers