Engineering

Depending on the context, this dialog box lets you update the logical model from a selected relational model or update a relational model from the logical model, control which parts of the logical model are reflected in a relational model, or restrict the types of objects and specific objects to be merged when two relational models are compared and merged.

Filter: You can include all objects, or only new, deleted, or modified objects.

Details

Displays detailed information about the selected model object.

General Options

Show Engineering in the Main Browser: Controls whether a check box is added for each object in the browser window, with the box checked if the object has been engineered.

Engineer Coordinates: Controls whether to position the tables resulting from the forward engineering process in the same way as their source entities.

Engineer Only Objects Created in "<model>": Controls whether only objects that were explicitly created in the specified model are engineered, or whether those objects plus other objects that were created as a result of previous forward or reverse engineering operations should be engineered.

Apply Name Translation: Controls whether formal names are translated to abbreviated names when the logical model is forward engineered to a relational model, and whether abbreviated names are translated to format names when a relational model is reverse engineered to the logical model. Name translation is applied only for valid names. In addition, translations between the words entity/attribute/key and table/column/index are performed.

Use Preferred Abbreviations: Controls whether any specified preferred abbreviations for entities and attributes are used for corresponding table and column names when the logical model is engineered to create a relational model.

Copy/Compare Options

Lets you select types of objects (entity/table, attribute/column, key/index, relation/foreign key, entity view/view), and for each pair indicate which of its properties are selected for use in the forward or reverse engineering operation. You can also specify the following options.

Show Selected Properties Only: Controls whether all properties for displayed objects are shown or only properties enabled (checked) under Selected.

Don't Apply for New Objects:

Exclude Unchecked Objects from Tree: Controls whether

Update Tree: Updates the logical and relational model tree displays to reflect the currently selected options.

Synchronization of Deleted Objects

Lets you select and deselect pairs of objects, with each pair containing a deleted object and the associated object to be deleted in the generated model in the pair is selected.

Overlapping and Folding Unique Identifiers (UIDs)

For engineering from the logical model to a relational model, displays information about any keys that overlap or are overlapped.