Compare Models

This dialog box lets you control the types of objects and specific objects to be merged when two relational models are compared and merged. Objects from the selected model in the file that you opened are on the left, and objects from the selected model in the currently open design are on the right.

You can expand and collapse the display of the relational models. If you select a specific table or view, the Details, Options, and perhaps other panes at the bottom display information for that object.

Filter: Lets you display all objects in both models, or display only new, deleted, or modified objects

To update the selected relational model in the current design by merging objects from the selected relational model in the external file, click Merge.

Options

Include Comments: Controls whether comments are included in the compare and merge operation.

DDL type: Type of DDL statements to be generated.

Replace Existing Files: Controls whether any existing DDL files will automatically be replaced.

Unload Directory: Directory or folder in which to save DDL files.