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 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 |
| 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 |
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
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?