Home > Data Modeler Dialog Boxes > 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
DDL Options
Include Comments: Controls whether comments are included in the compare and merge operation.
Include Logging: Controls whether logging information is included in the generated DDL statements.
Include Schema: Controls whether object names are prefixed with the schema name (for example, SCOTT.EMP
as opposed to just EMP
) in the generated DDL statements.
Include Storage: Controls whether storage information is included in the generated DDL statements.
Include Tablespace: Controls whether tablespace information is included in the generated DDL statements.
DDL type: Type of DDL statements to be generated: Regular DDL, Advanced Interactive DDL, or Advanced CL DDL
Advanced Interactive DDL and Advanced CL (command-line) DDL create a script with support for interactive (SQL*Plus or SQL Developer) or command-line (SQL*Plus only) setting of the following input parameters: start step, stop step, log file, and log level (1,2, or 3). Format for SQL*Plus execution of a resulting Advanced CL DDL script:
SQL> sqlplus user/password@name @script_name start_step stop_step log_file log_level
Replace Existing Files: Controls whether any existing DDL files will automatically be replaced.
Unload Directory: Directory or folder in which to save DDL files.
Compare Options
These options let you override defaults specified for the DDL: DDL/Comparison user preferences.
Date/Time Format
These options let you specify formats for dates, timestamps, and timestamps with time zone.
Tables That Will Be Recreated
For each table that need to be re-created, lists the table name and its settings for backup strategy (Backup or None), data restoration (Restore or None), script execution, and the unload directory.
For Script Execution, the possible values for all DDL types include Continue; and for Advanced Interactive DDL and Advanced CL DDL, the values also include Stop Before Backup, Stop After Backup, and Stop After Recreate.
Data Type Conversion
For each column with different source and target data types, lists the column name, current data type, new data type, and whether to re-create the table.
Oracle Errors to Mask
For Advanced DDL and Advanced CL DDL only: Specifies any Oracle errors to be ignored during script execution. For the error Number or Type, specify a hyphen and significant digits without leading zeroes; for example, specify -942 for ORA-00942. The error description is informational only and does not affect the script execution