Tag Archives: ddl

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 , , , ,

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 , ,