Tag Archives: Enterprise Architect

enterprise architect reverse engineering ddl

Posted on July 21, 2011 | Comments Off on enterprise architect reverse engineering ddl

after finally get my odbc oracle connection running, it was time to try out the reverse engineering… loading a existing database in ea… and it works…

  1. Create a new, empty ea project
  2. Goto Projects->Database Engineering->Import DB Schema form ODBC…
  3. Select the Database Name / ODBC
  4. Set a Schema/Owner
  5. Press Import
  6. Select the tables to import and press OK

tada… done… easy as hell, as soon as the odbc works :/

and really cool is the generate DDL function compare… when generating DDL, press the compare button and set the odbc… and view… so it shows you all the changes, and suggested actions… how to extract these, is some thing different :/ something for my next post 🙂

Comments Off on enterprise architect reverse engineering ddl

Posted in Uncategorized

Tagged , , , ,

ea: database model: create index

Posted on July 20, 2011 | Comments Off on ea: database model: create index

and enterprise architect can add indexes… just right-click on the table and select operations… und create the index… its a bit fency, because you need to create it, then select it, then tab to Column, and then you can select the columns, which need to be indexed… its confusing, because you select something on one tab, and then select other things on other tabs…

Comments Off on ea: database model: create index

Posted in Uncategorized

Tagged , ,

ea oracle datatypes

Posted on July 20, 2011 | Comments Off on ea oracle datatypes

as i told you before… working with enterprise architect and creating a database model for an oracle 11g database… and ea doesnt have the “timestamp” datatype… wft? so tried to figure out, if there is an ea update for newer oracle platforms… fail… but found this… exactly the same problem…

and a really simple solution… just define a new datatype:

Menu Settings->Database Datatypes

And define the database type for oracle…

simple… but spooky…

Comments Off on ea oracle datatypes

Posted in Uncategorized

Tagged , ,

database modeling with enterprise architect

Posted on July 20, 2011 | Comments Off on database modeling with enterprise architect

so finally got an Spary Enterprise Architect 🙂 the “:)” is kinda relative, because i really dont care, which program i should use for modeling tables and creating ddl’s… but the project said: use ea… and so i did… installing software in a really big company (as i am working now) can be really a pain… but after a few days, i got it up and runing… finally… so its kinda “:)”

and i think its really good… had a few problems in the beginning, created a table and colums, but couldn’t set columntypes, but master this problem… the table needs to know, which database it is in… kinda clear, but i thought the definition should be somewhere on the project or on the schema… not directly on the table…

so currently “painting” my model 🙂

Comments Off on database modeling with enterprise architect

Posted in Uncategorized

Tagged , ,