UModel and Databases

www.altova.com Print this Topic Previous Page Up One Level Next page

Home > 

UModel and Databases

You can import SQL databases into UModel in order to view their structure or modify it using UML (for a list of supported databases, see Database Support). UModel can conveniently display the database structure in UML Database diagrams similar to the one illustrated below.

sql-intro1

The following database elements can be imported to the database model:

 

Tables
Check Constraints
Primary / Foreign / Unique keys
Indices
Views
Triggers
Stored procedures
Functions

 

Note:Views, Triggers, Stored procedures and Functions can only be imported, though not added, in UModel.

 

After importing the database structure in UModel, you can modify it and apply the changes to the actual database, using the Merge Program Code from UModel project command. This creates a database change script file which can be executed, or saved for later execution. Alternatively, if changes took place in the database since the last synchronization, you can merge them into the model (or overwrite the model with the changes).

 

For information about how database elements map to UModel elements, see Database Mappings.


© 2019 Altova GmbH