Command Line Options for /datacompare Operation

Last modified: January 24, 2025

You can select the required options while setting the comparison in the Data Comparison wizard and generate a file with command line arguments by clicking Save settings to a command line arguments file on the Options wizard page. Also you can set comparison options by using the /option_name:[Y/N] switch in the Command Prompt. Specify either full or short names of the options. Here is the list of their names.

By default, dbForge Data Compare for Oracle generates a file with command line arguments and writes all comparison and synchronization options into it. Each option is written like the following: /option_name: [Y/N]

You can edit the file to turn on/off required options. To turn on comparison and synchronization options, edit their values to Yes, Y, True, T, or On. To turn off the options, change their values to No, N, False, F, or Off.

Each option has a full and short name. You can type either name of a required option into the Command Prompt instead of editing the file.

See below the list of options with their full and short command line names.

Options List

Command line option name	Short Name	Option
CheckConcurrencyUpdates	concupd	Check for concurrency updates.
CheckDifferent	chkdiff	Include different records into comparison results.
CheckIdentical	chkequal	Include identical records into comparison results.
CheckOnlyInSource	chksource	Include records that are available only in source into comparison results.
CheckOnlyInTarget	chktarget	Include records that are available only in target into comparison results.
CompareMViews	mviews	Include materialized views into comparison.
CompareNamesOnlyForBFiles	bfnames	Only file (and directory) names are compared regardless their content. Otherwise, the file content is compared and differences in file names are ignored. Allows to copy BFILEs to a target database.
CompareTables	tables	Include tables into comparison.
CompareViews	views	Include views into comparison.
CompileMViews	compmviews	Compile materialized views.
DifferentPerColumns	diffpercolumns	Show the number of differences for each column.
DisableDmlTriggers	nodml	Disable DML triggers.
DisableForeignKeys	nofk	Disable foreign keys.
DropKeys	dropkeys	Disable indexes.
ExcludeNewAddedObjects	excnewaddedobj	Exclude newly added objects.
ExcludeObjectsByMask	meobjmask	Allows specifying a custom wildcard expression for tables (or views) to exclude them from comparison.
IgnoreCase	icase	Ignore case in symbols for non-key columns of the following data types: CHARACTER, CHARACTER VARYING, TEXT.
IgnoreColumnsByMask	micolmask	Ignore columns by mask: ModifiedDate, CreatedOn, UpdatedBy.
IgnoreEndOfLine	ieol	Ignore end of line characters during comparison and synchronization.
IgnoreLeadingSpaces	ilspaces	Ignore leading spaces.
IgnoreLobColumns	milob	Allows ignoring LOB columns during comparison. The option can be applied to the following column types: (N)CLOUB, BLOB, BFILE, LONG, LONG RAW and XML.
IgnoreTrailingSpaces	ispaces	Ignore whitespaces in the end of strings during comparison and synchronization. This option can be applied to CHARACTER, CHARACTER VARYING, TEXT columns.
IgnoreWhiteSpace	ispaces	Ignore whitespaces.
IncludeComparisonSettings	incsettings	Compare and sync options.
ExcludeComments	nocomments	Prevent comments generation in a synchronization script.
IncludeObjectsByMask	miobjmask	Include tables or views by mask.
IncludeObjectsData	incdata	Include data records available in your database tables into your report.
IncludeOnlyColumnsWithChanges	inccolswchanges	Only data that contains differences will be added to the report.
IncludePrintComments	iprint	Include print comments.
IsIgnoreTime	itime	Ignore time part in DATETIME data types.
MappingIgnoreCase	micase	Ignore case in object names.
MappingIgnoreSpaces	mispace	Ignore spaces in object names.
MappingIgnoreUnderscores	miunder	Ignore underscores in object names.
RestoreSessionParameters	restoresession	Restore session parameters.
RollbackOnError	rollback	Rollback changes on synchronization error.
RoundFloatTypes	round	Round float types up to 3 digits.
SynchronizeSequences	syncseq	Synchronize current values of sequences.
ToleranceInterval	tol	Tolerance interval.
UseSchemaNamePrefix	fullnames	Generate fully qualified object names.
UseSqlExtensionCommands	sqlplus	Use SQL *Plus commands.
ReseedIdentityColumns	reseed	Reseeds current values for identity columns and properly modifies the START WITH values for the IDENTITY columns.