By default, dbForge Data Compare for Oracle generates a file with command line arguments and records all comparison and synchronization options into it. Each option is displayed in the format:
/option_name:[Y/N]
You can edit the file to turn on/off the required options. To turn on comparison and synchronization options, set their values to “Yes”, “Y”, “True”, “T”, or “On”. To turn off the options, use “No”, “N”, “False”, “F”, or “Off”.
Each option has both a full name and a short name. Instead of editing the file, you can specify the desired option directly in the Command Prompt.
See below the list of options with their full and short command line names.
The table provides comparison and synchronization options with their full and short command-line names.
| Full name | Short name | Description |
|---|---|---|
| CheckConcurrencyUpdates | concupd | Prevents accidental data overwrites by adding non-key conditions to the WHERE clause of UPDATE and DELETE statements, and by using SELECT ... WHERE NOT EXISTS checks before INSERT statements. |
| CheckDifferent | chkdiff | Includes different records in comparison results. The records can then be selected for synchronization. |
| CheckIdentical | chkequal | Includes identical records in comparison results. |
| CheckOnlyInSource | chksource | Includes only source records in comparison results. The records can then be selected for synchronization. |
| CheckOnlyInTarget | chktarget | Includes only target records in comparison results. The records can then be selected for synchronization. |
| CompareMViews | mviews | Compares materialized views and includes them in the comparison results. Note: Materialized views can’t be synchronized. |
| CompareNamesOnlyForBFiles | bfnames | Compares only file and directory names, ignoring their contents. By default, file contents are compared and name differences are ignored. The option allows copying BFILE data type to the target database. |
| CompareTables | tables | Compares tables and includes them in comparison results. |
| CompareViews | views | Compares views and includes them in comparison results. |
| CompileMViews | compmviews | Refreshes data in materialized views after script execution. |
| DisableDmlTriggers | nodml | Disables DML triggers at the beginning of synchronization and re-enables them after synchronization completes. The option applies to tables. |
| DisableForeignKeys | nofk | Disables foreign keys at the beginning of synchronization and enables them after synchronization completes. |
| DropCheckConstraints | dropcheck | Drops the CHECK and NOT NULL constraints at the beginning of synchronization and restores them after synchronization completes. |
| DropKeys | dropkeys | Disables non-unique indexes at the beginning of synchronization and re-enables them after synchronization completes. |
| ExcludeComments | nocomments | Excludes comments from a synchronization script. |
| ExcludeNewAddedObjects | excnewaddedobj | Compares only tables and views explicitly included in the saved project (.dcomp). |
| ExcludeObjectsByMask | meobjmask | Excludes tables, views, or materialized views from comparison based on a custom wildcard or regular expression. |
| IgnoreCase | icase | Ignores the case of (N)CHAR, (N)VARCHAR2, (N)CLOB, and LONG columns. The option doesn’t affect key comparison columns. |
| IgnoreColumnsByMask | micolmask | Excludes columns from comparison based on a custom wildcard or regular expression. |
| IgnoreComputedColumns | micomput | Excludes computed columns from comparison. |
| IgnoreEndOfLine | ieol | Ignores all carriage return and line feed characters during comparison. The option applies to (N)CHAR, (N)VARCHAR2, (N)CLOB, and LONG columns. It doesn’t affect key comparison columns.Note: Using the option with (N)CLOB may slow down comparison. |
| IgnoreIdentityColumns | miident | Ignores identity columns during comparison and synchronization. |
| IgnoreInternalSpaces | iispaces | Ignores spaces, tabs, and other non-printable characters inside a string during comparison. The option applies to (N)CHAR, (N)VARCHAR2, (N)CLOB, and LONG columns. It doesn’t affect key comparison columns.Note: Using the option with (N)CLOB may slow down comparison. |
| IgnoreLeadingSpaces | ilspaces | Ignores leading spaces, tabs, and other non-printable characters in a string during comparison. The option applies to (N)CHAR, (N)VARCHAR2, (N)CLOB, and LONG. It doesn’t affect key comparison columns.Note: Using the option with (N)CLOB may slow down comparison. |
| IgnoreLobColumns | milob | Excludes LOB columns from comparison. The option applies to BLOB, (N)CLOB, XMLTYPE, BFILE, LONG, and LONG RAW. |
| IgnoreTrailingSpaces | itspaces | Ignores spaces, tabs, and other non-printable characters at the end of a string during comparison. The option applies to CHAR, NCHAR, VARCHAR2, NVARCHAR2, CLOB, and NCLOB columns. It doesn’t affect key comparison columns.Note: Using the option with CLOB or NCLOB may slow down comparison. |
| IgnoreWhiteSpace | ispaces | Ignores whitespace characters during comparison of triggers, stored procedures, stored functions, packages, and package bodies. Original whitespaces in script object bodies are preserved during synchronization. |
| IncludeObjectsByMask | miobjmask | Compares only tables, views, or materialized views that match a specified wildcard or regular expression mask. |
| IncludePrintComments | iprint | Displays comments explaining synchronization actions during script execution. |
| IsIgnoreTime | itime | Ignores the time component of datetime values during comparison. The option applies to TIMESTAMP. |
| MappingIgnoreCase | micase | Ignores lower and upper case differences in object names when mapping them. |
| MappingIgnoreSpaces | mispace | Ignores spaces in object names when mapping them. |
| MappingIgnoreUnderscores | miunder | Ignores underscores in object names when mapping them. |
| ReseedIdentityColumns | reseed | Resets the current identity value and updates the START WITH value in the IDENTITY column property. |
| RestoreSessionParameters | restoresession | Restores session parameters, including NLS_DATE_FORMAT, NLS_NUMERIC_CHARACTERS, NLS_TIMESTAMP_TZ_FORMAT, NLS_TIMESTAMP_FORMAT, NLS_NCHAR_CONV_EXCP, and TIME_ZONE, after synchronization completes. |
| RollbackOnError | rollback | Restores a database to its previous state if an error occurs during synchronization. |
| RoundFloatTypes | round | Rounds float types up to 3 digits. The option applies to NUMBER, BINARY_FLOAT, and BINARY_DOUBLE. It doesn’t affect key columns. |
| SynchronizeSequences | syncseq | Synchronizes the current values of sequences. When synchronization starts or a synchronization script is generated, CURRVAL is set to the INCREMENT BY value on both source and target. |
| ToleranceInterval | tol | Specifies the maximum allowed difference (absolute value) between source and target values. If the difference doesn’t exceed this value, the values are considered equal. The option applies to NUMBER, BINARY_FLOAT, and BINARY_DOUBLE. It doesn’t affect key columns. |
| UseSchemaNamePrefix | fullnames | Generates fully qualified object names, including schema names, in a synchronization script. |
| UseSqlExtensionCommands | sqlplus | Enables the use of SQL extension commands during script generation and execution. |
| Full name | Short name | Description |
|---|---|---|
| AppendTimestampReport | tsreport | Adds a timestamp to the folder name of a generated comparison report. |
| DifferentPerColumns | diffpercolumns | Displays the number of differences per column. |
| HideUnmodifiedColumns | hidecolumns | Excludes columns with no differences. |
| IncludeComparisonSettings | incsettings | Includes comparison and synchronization settings in a comparison report. |
| IncludeObjectsData | incdata | Includes object data in a comparison report. |
| IncludeSyncWarnings | incwarnings | Includes comparison or synchronization warnings in the report, if any. |
/datacompare /compfile:"D:\workDir\OSC1vsOSC2.dcomp"
/datacompare /source host:OracleServer1 user:sys password:pswd database:db1 /target host:OracleServer2 user:sys password:pswd database:db2 /sync /log:"D:\sync.log"
/datacompare /source host:OracleServer1 database:db1 user:sys password:pswd /target host:OracleServer2 database:db2 user:sys password:pswd /sync:"D:\compare_result.sql"
/datacompare /compfile:"OSC1vsOSC2.dcomp" /icase:yes /report:"report.html" /reportformat:HTML /sync