Data comparison and synchronization options used in the command line

Last modified: January 31, 2023

This topic gives a detailed description of command-line options.

Command line usage

dbforgepostgresql [/argfile:path] [/option_name1[:value | [parameter1:value parameter2:value ..]] /option_name2 ..]

The first argument for dbforgepostgresql is usually an operation switch that corresponds to the operation that you want to perform with the application. For data comparison, it is /datacompare.

You can edit the file to turn on/off the 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.

Below is the list of options with their full and short command line names.

Options list

Full name	Short name	Option
BulkInsert	bulk	Insert multiple rows into a table using a single INSERT statement
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 only in source records into comparison results
CheckOnlyInTarget	chktarget	Include only in target records into comparison results
CompareTables	tables	Include tables into comparison
CompareViews	views	Include views into comparison
DisableDmlTriggers	nodml	Disable DML triggers in the beginning of synchronization
DisableForeignKeys	nofk	Disable foreign keys in the beginning of synchronization
DisableRules	norules	Disable rules
DropCheckConstraints	dropcheck	Drop check and not null constraints in the beginning of synchronization
DropKeys	dropkeys	Disable primary keys, indexes and unique constraints
ExcludeComments	nocomments	Prevent comments generation in a synchronization script
ExcludeNewAddedObjects	excnewaddedobj	Compare only those tables and views that are explicitly included in the saved project (*.dcomp)
ExcludeObjectsByMask	meobjmask	Exclude tables or views by mask
ExecuteAsSingleTransaction	tran	Execute a synchronization script as a single transaction
IgnoreCase	icase	Ignore case in symbols for non-key columns
IgnoreColumnsByMask	micolmask	Specify a custom wildcard expression for columns names to exclude columns from comparison
IgnoreComputedColumns	micomput	Ignore computed columns
IgnoreEndOfLine	ieol	Ignore end of line characters during comparison and synchronization
IgnoreInternalSpaces	iispaces	Ignore internal spaces during comparison and synchronization
IgnoreLeadingSpaces	ilspaces	Ignore leading spaces
IgnoreLobColumns	milob	Ignore lob columns during comparison
IgnoreSerialColumns	miserial	Exclude SERIAL, SMALLSERIAL, and BIGSERIAL columns from comparison
IgnoreTrailingSpaces	ispaces	Ignore whitespaces in the end of strings during comparison and synchronization
IncludeComparisonSettings	incsettings	Include comparison settings
IncludeDifferencesPerColumns	incdiffcols	Include differences per columns
IncludeObjectsByMask	miobjmask	Specify a custom wildcard expression for database objects to include them into comparison
IncludeObjectsData	incdata	Include objects data
IncludeOnlyColumnsWithChanges	inccolswchanges	Include only columns with changes
IncludeSyncScript	incscript	Add synchronization script
IncludeSyncWarnings	incwarn	Add synchronization warnings
IsEmptyStringEqualsNull	emptyeqnull	Treat NULL and EMPTY STRING as the same value
IsIgnoreTime	itime	Ignore time for fileds of the DATETIME type and compare only dates
MappingIgnoreCase	micase	Ignore case in object names when mapping them
MappingIgnoreSpaces	mispace	Ignore spaces in object names when mapping them
MappingIgnoreUnderscores	miunder	Ignore underscore in object names when mapping them
RoundFloatTypes	round	Round float types up to 3 digits
ToleranceInterval	tol	Specifies the tolerance range for comparing the source and target values