Two Data Modeling Questions

[Ed Lucas]

1.  I've successfully reverse-engineered a few schemas from existing databases using the Project -> Database Engineering -> Import DB Schema from ODBC option.  My question is:  Is there a way to reverse engineer a data model into Sparx directly from DDL scripts without having to actually run the DDLs against a DB and then reverse from there?

2.  When I manually "Add Model" of type "Database", and I subsequently manually create a new table, for whatever reason, I am unable to specify a data type for a column.  The dropdown isn't disabled, but there's nothing I can choose.  Am I missing some kind of config step before I can specify data types?  (Like perhaps choosing a database variant or some such?)  If not, what am I doing wrong?

Many thanks,

-- Ed

[Geert Bellekens]

1. No, only from a live database
2. Yes you have to define a database type. You can set the default type at Settings/Database Datatypes, and set them individually for each class in the properties dialog.

Geert

[skiwi]

My question is:  Is there a way to reverse engineer a data model into Sparx directly from DDL scripts without having to actually run the DDLs against a DB and then reverse from there?
-- Ed

Now there is a feature I would appreciate

[sargasso]

ALTER FUNCTION name ( [ [ argmode ] [ argname ] argtype [, ...] ] )
    SET SCHEMA new_schema



the prosecution rests.

b

[Steven Tuften]

All, Please post your request for this feature to Sparx !

It has caused me a huge amount of pain   as I've been unable for to reverse engineer directly from a DB2 z/OS db so have had to resort to importing the DDL extracted for me by the DBAs.

DDL went into erwin then exporting out as CSV then imported into EA using a custom automation script. Not an ideal process when most data modelling tools have the capability to import from DDL.

Ok, I've vented now. I feel better.