Generate DDL

[mikea59]

My fist post...

I'm a EA newb and I'm trying to do, what seems like, a very simple thing. I'm trying to generate DDL from a data model. When I bring up the Generate DDL dialog it gives me an error saying "Database not defined" - what database do I have to define? I don't want or need to store me EA model in a DB. Do I need to create a DB anyway? I'm not trying to reverse engineer a DB, I'm trying to generate a DB (actually, just some DDL) from a data model. Do I actually have to create the database I am trying to build? The documentation was not all that helpful in this area, at least I couldn't find it - any help would be greatly appreciated.

[hd]

EA is asking you to define the target DBMS for the DDL, be it SQL Server, Oracle, or one of the supported DBMS. There's a drop down list of DBMS on the table properties dialog. You can set a default (before creating tables) from Tools | Options | Code Editors | Default Database.

How did you define data types for the columns? You would have needed the database set in order to define the data types.

[mikea59]

I was using the EAExample project. I loaded that project, went to Options->Code Editors and set my default database to Oracle. So, the tables were created before I set the default DB and I get the error. I then went into the Class->Properties screen and noticed the General tab had a Database: field - set it to Oracle and it worked -thanks.