Command line options for the /schemacompare operation

Last modified: February 7, 2025

By default, dbForge Studio for SQL Server generates a file with command line arguments and writes all the 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 Command Prompt instead of editing the file.

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

Command line option name	Short name	Option
CompareDatabaseProperties	cdbp	Compare database properties
DecryptEncryptedObjects	decrypt	Decrypt encrypted objects
ForceColumnOrder	force	Force column order
IgnoreAuthorization	iauth	Ignore authorization on schema objects
IgnoreBoundRulesDefaults	iboundruldef	Ignore bound rules and defaults
IgnoreCase	icase	Ignore case
IgnoreChangeTracking	itracking	Ignore CHANGE_TRACKING clauses and statements
IgnoreCheckConstraints	icheck	Ignore check constraints
IgnoreClrDataTypesInColumn	icdtc	Ignore CLR datatypes in columns
IgnoreCollations	icollate	Ignore collations
IgnoreColumnOrderInIndexes	mindcolorder	Ignore column order for the included columns in indexes
IgnoreComments	icomment	Ignore comments
IgnoreConstraintsNames	icnames	Ignore constraints’ names
IgnoreConstraintSystemNames	icsn	Ignore constraints’ system names
IgnoreDatabaseExtendedProperties	idbprop	Ignore database extended properties
IgnoreDatabaseInSynonyms	idbsyn	Ignore database and sever names in synonyms
IgnoreDatabaseObjectExtendedProperties	iobjprop	Ignore database object extended properties
IgnoreDataCompression	idatacompression	Ignore DATA COMPRESSION
IgnoreDataTypesInColumn	idtc	Ignore data types in column
IgnoreDDLTriggerState	iddltstate	Ignore state of DDL triggers
IgnoreDefaultCollations	idefcollate	Ignore default column collations
IgnoreDefaultConstraints	idefault	Ignore default constraints
IgnoreDMLTriggerState	idmltstate	Ignore state of DML triggers
IgnoreDropDMLTriggers	idropt	Ignore DML and INSTEAD OF triggers present only in Target
IgnoreDropIndexes	idropi	Ignore indexes present only in Target
IgnoreEventNotificationOnQueues	ievent	Ignore event notification on queues
IgnoreFilegroupsPartitionSchemes	istorage	Ignore filegroups and partitioned schemes/functions
IgnoreForeignKeyActions	ifkacts	Ignore foreign keys actions ON UPDATE and ON DELETE
IgnoreForeignKeys	ifk	Ignore foreign keys
IgnoreFullTextCatalogPath	iftpath	Ignore full-text catalog path
IgnoreFullTextSearch	isearch	Ignore full-text search
IgnoreIdentity	iidentity	Ignore identity on columns
IgnoreIdentitySeedIncrementValues	iseed	Ignore identity seed and increment values
IgnoreIndexColumnsSortOrder	iicso	Ignore sort direction (ASC/DESC) for index columns
IgnoreIndexes	iindex	Ignore indexes
IgnoreIndexesNames	iinames	Ignore indexes names
IgnoreIndexPageAndRowLock	iprlock	Ignore PAGE LOCKS and ROW LOCKS for indexes and constraints
IgnoreInsteadOfTriggers	iotrig	Ignore INSTEAD OF triggers
IgnoreKeywordReduction	ired	Ignore keyword reduction
IgnoreLockEscalation	ils	Ignore LOCK_ESCALATION
IgnoreLogins	ilogin	Ignore logins, certificates, asymmetric keys for users
IgnoreNextFilegroups	inextfg	Ignore next filegroups
IgnoreNocheck	inocheck	Ignore NOCHECK
IgnoreNotForReplication	ireplication	Ignore NOT FOR REPLICATION
IgnoreNotNullConstraints	inotnull	Ignore NOT NULL for a column
IgnoreObjectNamesInDefinitions	ion	Ignore object names in definintions
IgnorePadIndexAndFillfactor	ipiff	Ignore PAD INDEX and FILLFACTOR for indexes and constraints
IgnoreParserErrors	iparsererrors	Ignore parser errors
IgnorePermissions	iperm	Ignore permissions
IgnorePrimaryKeys	ipk	Ignore primary keys
IgnoreQuotedIdentifierAndANSINulls	iquotansi	Ignore QUOTED IDENTIFIERS and ANSI NULLS
IgnoreReplicatedProcedures	irproc	Ignore replication procedures
IgnoreReplicatedRoles	irrole	Ignore replication roles
IgnoreReplicatedSchemas	irschem	Ignore replication schemas
IgnoreReplicatedTables	irept	Ignore replicated tables
IgnoreReplicationTriggers	irtrig	Ignore replication triggers
IgnoreSemicolons	isc	Ignore semicolons
IgnoreSequenceMax	iseqmax	Ignore sequence max value
IgnoreSequenceMin	iseqmin	Ignore sequence min value
IgnoreSequencesCache	iseqcache	Ignore CACHE in sequences during comparison and synchronization
IgnoreSequencesCycle	iseqcycle	Ignore CYCLE in sequences during comparison and synchronization
IgnoreSequencesIncrementBy	iseqinc	Ignores INCREMENT BY in sequences during comparison and synchronization
IgnoreSequencesInitials	iseqst	Ignore START WITH in sequences during comparison and synchronization
IgnoreSequencesMinValue	iseqmv	Ignore MIN VALUE in sequences during comparison and synchronization
IgnoreSequenceStart	iseqstart	Ignore sequence start value
IgnoreSignatures	isign	Ignore signatures
IgnoreStatistics	istat	Ignore statistics
IgnoreStatisticsNorecompute	isnr	Ignore STATISTICS, NORECOMPUTE for indexes and constraints
IgnoreTableDMLTriggers	itdmltrig	Ignode table DML triggers
IgnoreTriggerFireOrder	ifire	Ignore firing order for DDL and DML triggers
IgnoreTSQLtFramework	itsqlt	Ignore tSQLt framework and unit tests
IgnoreUniqueKeys	iuk	Ignore unique keys
IgnoreUserDefaultLanguage	iudeflang	Ignore user DEFAULT_LANGUAGE
IgnoreUserDefaultSchema	iuds	Ignore user DEFAULT SCHEMA
IgnoreUserPermissions	iuperm	Ignore users’ permissions
IgnoreWhiteSpace	ispace	Ignore white spaces (newlines, tabs, spaces, etc.) during comparison and synchronization
IgnoreWithEncryption	iwenc	Ignore WITH ENCRYPTION
IgnoreWithNocheck	iwnocheck	Ignore WITH NOCHECK state on constraints
IgnoreWithOptionOrder	iwith	Ignore WITH option order
MappingIgnoreCase	micase	Ignore case in object names when mapping them
MappingIgnoreSpaces	mispace	Ignore spaces in object names druing mapping and comparing
MappingSimilar	msim	Associate column names having similar name options
PopulateFullTextIndexes	populate	Populate full-text indexes
QuoteObjectNames	quote	Quote object names with square brackets
UserDataTypesToSystem	udttosys	Convert user data types into SQL Server system data types
AddBackupType	addbt	Add backup type
AddingErrorHandling	adderrorhandle	Add error handling statements
AddTransactionIsolationLevel	addtransiso	Set transaction isolation level
AddWithEncryption	addwithencr	Add WITH ENCRYPTION
AddWithNocheck	addnocheck	Add constraints and keys to tables using WITH NOCHECK
BackupExtension	extbackup	Extension for backup file
CheckObjectExistence	cexist	Check for object existence
CommentDdlForKeysCertificates	commentkeys	Comment DDL statements for signatures, certificates, asymmetric and symmetric keys
CreateBackupFolder	cbackupfolder	—
BackupType	bt	Backup type
DeployDatabaseInSingleUserMode	depsingl	Synchronize database in the single user mode
DisableDdlTriggers	noddl	Disable DDL triggers during synchronization
DropCreateOnly	dropcreateonly	Use DROP and CREATE instead of ALTER
DropCreateOnlyAssemblies	dropcreateonlya	Use DROP and CREATE instead of ALTER for assemblies
DropCreateOnlyTables	dropcreateonlyt	Use DROP and CREATE instead of ALTER for tables
ExcludeComments	nocomments	Exclude comments
ExcludeDependencies	edep	Exclude dependencies
ExecuteAsSingleTransaction	tran	Execute a synchronization script as a single transaction
IncludePrintComments	iprint	Include print comments in the deployment script
IncludeUseDatabase	inud	Include USE / clause to the script
NeedCompressBackup	comprbackup	Use compression for backup
RefreshViews	rview	Exclude dependencies from a synchronization script
SynchronizeAsmViaFiles	asmviafiles	Synchronize assemblies via files
UseSchemaTransfer	ust	Use ALTER SCHEMA TRANSFER expression to transfer tables between schemas
VerifyTableData	verify	Verify table data using checksum
IncludeComparisonSettings	incsettings	Includes identical objects into your report
IncludeIdenticalObjects	incident	Includes comparison options into your report. This option is available only for HTML reports
SelectedObjectsOnly	selobjonly	Includes objects selected for synchronization into your report