Command Line Options for /schemacompare Operation

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
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 space
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