Topics
Prev Next

Database Engineering

This topic provides answers to frequently-asked questions related to forward and reverse engineering DBMS structures using Enterprise Architect.

Database Engineering

Question

Answer

See also

How do I generate a diagram when I reverse engineer a DBMS database?

To ensure that a diagram is generated when you reverse engineer a database as a simple import (rather than via the Database Builder) firstly ensure that you create a Data Modeling diagram. 

See the Import Database Schema Using a Diagram table of the Import Database Schema Help topic.

Import Database Schema

How do I get a Data Dictionary from the model?

You can use a simple Model Search query providing a Data Dictionary, as shown in the Data Dictionary section in the Appendix of the Data Modeling - From Conceptual Model to DBMS white paper.

Data Modeling whitepaper

How do I compare my model with the current DBMS structure?

The Database Builder provides a 'Database Compare' option for easily comparing the model with an existing DBMS, such as the testing DBMS or the production DBMS.

Database Compare The Database Builder

Can I reverse engineer a database from DDL?

Enterprise Architect is designed to work interactively with the DBMS being modeled.  A Database schema import is only possible through an ODBC connection with a live database. It does not support import of a database schema from a DDL text file. For further details, refer to the Import Database Schema Help topic.

Import Database Schema