By default, dbForge Studio for SQL Server automatically generates a .txt file with command-line arguments. You can configure comparison options in the New Data Comparison wizard and then save them to this .txt file.
Alternatively, you can configure comparison options from the command line by using the /options switch and specifying either full or short names of the options.
dbforgesql.com /datacompare [/option_name1[:value | [parameter1:value parameter2:value ..]] /option_name2 ..]
To turn the option on, specify: Yes, Y, On, True, or T.
To turn the option off, specify: No, N, Off, False, or F.
The table provides a list of comparison and synchronization options with their full and short command-line names.
| Full name | Short name | Description |
|---|---|---|
| AddBackupType | addbt | Adds a backup type. |
| AddingErrorHandling | adderrorhandle | Adds error handling statements. |
| AddTransactionIsolationLevel | addtransiso | Sets a transaction isolation level. |
| BackupExtension | extbackup | Specifies the extension for the backup file. |
| BulkInsert | bi | Uses BULK INSERT for data insertion. |
| CheckConcurrencyUpdates | concupd | Checks for concurrency updates. |
| CheckDifferent | chkdiff | Includes different records into comparison results. |
| CheckIdentical | chkequal | Includes identical records into comparison results. |
| CheckOnlyInSource | chksource | Includes only source records into comparison results. |
| CheckOnlyInTarget | chktarget | Includes only target records into comparison results. |
| CompareClrTypesAsBinary | clrasbin | Compares and synchronizes CLR types as binary, otherwise as a string. |
| CompareColumnStoreTables | colstore | Compares tables with COLUMNSTORE indexes. |
| CompareMemoryOptimizedTables | moptimize | Compares memory-optimized tables. |
| CompareTables | tables | Includes tables into comparison. |
| CompareTemporalHistoryTable | history | Includes history tables for temporal tables in comparison. |
| CompareViews | views | Includes views in the comparison. |
| CreateBackupFolder | cbackupfolder | Creates a folder for the database backup. |
| DisableDdlTriggers | noddl | Disables DDL triggers at the beginning of synchronization. |
| DisableDmlTriggers | nodml | Disables DML triggers at the beginning of synchronization. |
| DisableForeignKeys | nofk | Disables foreign keys at the beginning of synchronization. |
| DropCheckConstraints | dropcheck | Drops CHECK and NOT NULL constraints at the beginning of synchronization. |
| DropKeys | dropkeys | Disables primary keys, indexes, and unique constraints. |
| ExcludeComments | nocomments | Excludes comments from a synchronization script. |
| ExcludeNewAddedObjects | excnewaddedobj | Compares only those tables and views that are explicitly included in the saved project (.dcomp). |
| ExcludeObjectsByMask | meobjmask | Excludes tables or views by mask. |
| ExecuteAsSingleTransaction | tran | Executes a synchronization script as a single transaction. |
| FileStoragePath | fspath | Specifies a backup file location. |
| IgnoreCase | icase | Ignores lower case and upper case differences for non-key columns. |
| IgnoreBlobColumns | miblob | Ignores blob columns during comparison. |
| IgnoreColumnsByMask | micolmask | Specifies a custom wildcard expression for column names to exclude columns from comparison. |
| IgnoreComputedColumns | micomput | Ignores computed columns. |
| IgnoreEndOfLine | ieol | Ignores the end of line characters during comparison and synchronization. |
| IgnoreIdentityColumns | miident | Ignores identity columns during comparison. |
| IgnoreInternalSpaces | iispaces | Ignores spaces, tabs, and other non-printable characters in the middle of strings during comparison. |
| IgnoreLeadingSpaces | ilspaces | Ignores leading spaces. |
| IgnoreRowguidColumns | mirowguid | Ignores ROWGUID columns during comparison. |
| IgnoreTemporalTableSysColumns | isyscol | Ignores SYSTEM_TIME columns for temporal tables. |
| IgnoreTimestampColumns | mitime | Ignores TIMESTAMP columns during comparison. |
| IgnoreTrailingSpaces | itspaces | Ignores spaces, tabs, and other non-printable characters at the end of strings during comparison. |
| IgnoreWhiteSpace | ispaces | Ignores whitespace characters during comparison and synchronization. |
| IncludeObjectsByMask | miobjmask | Includes tables or views by mask. |
| IncludePrintComments | iprint | Includes print comments in the output during the script execution. |
| IncludeUseDatabase | inud | Adds the USE <database_name> clause to the script. |
| IsEmptyStringEqualsNull | emptyeqnull | Treats NULL and EMPTY STRING as the same value. |
| IsIgnoreTime | itime | Ignores time for fields of the DATETIME type and compares only dates. |
| MappingIgnoreCase | micase | Ignores lower case 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. |
| NeedCompressBackup | comprbackup | Performs a compressed backup. |
| ReseedIdentityColumns | reseed | Reseeds the current value for identity columns. |
| RestoreConstraintsWithCheck | checkconstrrestore | Restores constraints with CHECK. |
| RoundFloatTypes | round | Rounds float types up to 3 digits. |
| 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. |
| UseSchemaNamePrefix | fullnames | Generates fully qualified object names. |
The table describes comparison report options.
| Full name | Short name | Description |
|---|---|---|
| AppendTimestampReport | tsreport | Generates a comparison report with a timestamp. |
| DifferentPerColumns | diffpercolumns | Includes differences per column. |
| HideUnmodifiedColumns | hidecolumns | Excludes columns without differences from a comparison report. |
| IncludeComparisonSettings | incsettings | Includes comparison settings into the report. |
| IncludeIdenticalObjects | incident | Includes identical objects. |
| IncludeObjectsData | incdata | Includes object data. |
| IncludeSyncWarnings | incwarnings | Includes synchronization warnings. |