Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Database Developers
Enterprise Architect supports a range of features for the development of databases, including modeling database structures, importing database structures from an existing database and generating DDL for rapidly creating databases from a model.
Database Development Tasks
Topic |
Detail |
See also |
||||||||||||||||||||
Create Logical Data Models |
With Enterprise Architect the Database developer can build database diagrams using the built-in UML Data Modeling Profile. This supports the definition of Primary and Foreign keys, cardinality, validation, triggers, constraints and indexes.
|
|||||||||||||||||||||
Generate Schema |
By using Enterprise Architect's DDL generation function the Database Administrator can create a DDL script for creation of the database table structure from the model. Enterprise Architect currently supports:
|
|||||||||||||||||||||
Reverse Engineer Database |
Using an ODBC data connection the Database Administrator can import a database structure from an existing database to create a model of the database. Generating the model directly from the database enables the DBA to quickly document their work and create a diagrammatic account of a complex database through the graphical benefits of UML.
|
|||||||||||||||||||||
Example |
|
|
Learn more
