Options used in Command Line for /datacompare

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 SQL Server 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

Full Name Short Name Option
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
CompareClrTypesAsBinary clrasbin Compare and synchornize CLR types as binary, otherwise as string
CompareColumnStoreTables colstore Compare tables with COLUMNSTORE indexes
CompareMemoryOptimizedTables moptimize Compare memory optimized tables
CompareTables tables Include tables into comparison
CompareViews views Include views into comparison
ExcludeObjectsByMask meobjmask Exclude tables or views by mask
IgnoreBlobColumns miblob Ignore blob columns during comparison
IgnoreCase icase Ignore case in symbols for non-key columns
IgnoreColumnsByMask micolmask Specify a custom wildcart 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
IgnoreIdentityColumns miident Ignore identity columns during comparison
IgnoreLeadingSpaces ilspaces Ignore leading spaces
IgnoreRowguidColumns mirowguid Ignore ROWGUID columns during comparison
IgnoreTemporalTableSysColumns isyscol Ignore coumn is SYSTEM_TIME for temporal tables
IgnoreTimestampColumns mitime Ignore TIMESTAMP columns during comparison
IgnoreTrailingSpaces ispaces Ignore whitespaces in the end of strings during comparison and synchronization
IncludeObjectsByMask miobjmask Include tables or views by mask
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
BulkInsert bi Use bulk insert for data insertion
CheckConcurrencyUpdates concupd Check for the concurrecncy updates
CreateBackupFolder cbackupfolder Create folder for database backup
DisableDdlTriggers noddl Disable DDL triggers in the beginning of synchronization
DisableDmlTriggers nodml Disable DML triggers in the beginning of synchronization
DisableForeignKeys nofk Disable foreign keys in the beginning of synchronization
DropCheckConstraints dropcheck Drop check and not null constraints in the beginning of synchronization
DropKeys dropkeys Disable primary keys, indexes and unique constraints
ExecuteAsSingleTransaction tran Execute a synchronization script as a single transaction
FileStoragePath fspath Specify a backup file location
IncludePrintComments iprint Include print comments into output while executing the script
ReseedIdentityColumns reseed Reseed a current value for identity columns
RestoreConstraintsWithCheck checkconstrrestore Restore constraints with CHECK
UseSchemaNamePrefix fullnames Generate fully qualified object names
IncludeComparisonSettings incsettings Include comparison settings
IncludeDifferencesPerColumns incdiffcols Include differences per columns
IncludeIdenticalObjects incident Include identical objects
IncludeObjectsData incdata Include objects data
IncludeOnlyColumnsWithChanges inccolswchanges Include only columns with changes

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?