By default, dbForge Studio for SQL Server automatically generates a .txt file with command-line arguments. You can configure comparison options in the New Schema 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 /schemacompare [/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 |
|---|---|---|
| CompareDatabaseProperties | cdbp | Includes a database object in comparison and synchronization. Note: The database object is synchronized even if the Compare database properties option is turned off, if the object depends on other objects that are selected for synchronization. |
| CompareOriginalScriptsStoredObjects | corigscript | Compares and synchronizes the original scripts of stored objects. This setting applies to procedures, functions, views, and DDL and DML triggers. |
| DecryptEncryptedObjects | decrypt | Decrypts bodies of encrypted objects for comparison and synchronization. They are shown in the comparison results as usual script objects. If you compare encrypted objects in databases with large bulks of data, using this option will slightly slow down schema comparison. |
| ForceColumnOrder | force | Preserves the column order. |
| IgnoreAuthorization | iauth | Ignores AUTHORIZATION clauses on database-contained objects during comparison and synchronization. Target authorizations are preserved if possible. |
| IgnoreBoundRulesDefaults | iboundruldef | Ignores bound rules and defaults during comparison and synchronization. |
| IgnoreCase | icase | Ignores any case differences in object body during comparison. |
| IgnoreChangeTracking | itracking | Ignores CHANGE_TRACKING clauses and statements during comparison and synchronization. |
| IgnoreCheckConstraints | icheck | Ignores CHECK constraints during comparison and synchronization. CHECK constraints aren’t restored if, for example, the data type of the column it is related to was changed. In this case, the CHECK constraint condition may become invalid. |
| IgnoreClrDataTypesInColumn | icdtc | Ignores CLR data types in columns during comparison and synchronization. CLR data types in columns in the target tables are preserved if possible. |
| IgnoreCollations | icollate | Ignores column collations during comparison and synchronization. Collations are canceled if a data type in the column was changed to a non-text one regardless of whether the Ignore collations option was selected or not. |
| IgnoreColumnOrderInIndexes | mindcolorder | Ignores the column order for the included columns in indexes during comparison and synchronization. |
| IgnoreComments | icomment | Ignores comments during comparison of views, stored procedures, or functions. During synchronization, comments are preserved in the body of the script object. |
| IgnoreConstraintsNames | icnames | Ignores constraint names during comparison and synchronization.CHECK constraints are preserved in the target. |
| IgnoreConstraintSystemNames | icsn | Ignores constraint system names. |
| IgnoreDatabaseExtendedProperties | idbprop | Ignores database extended properties. They are preserved after synchronization if a database that refers to these extended properties is rebuilt. |
| IgnoreDatabaseInSynonyms | idbsyn | Ignores database and server names for synonyms. |
| IgnoreDatabaseObjectExtendedProperties | iobjprop | Ignores extended properties of database objects. These properties are preserved after synchronization if an object that refers to them is rebuilt. |
| IgnoreDataCompression | idatacompression | Ignores a DATA COMPRESSION clause for tables, indexes, primary and unique key constraints. It is preserved in the target database. |
| IgnoreDataTypesInColumn | idtc | Ignores data types in columns. They are preserved in the target database if possible. |
| IgnoreDDLTriggerState | iddltstate | Ignores the state of DDL triggers. It is preserved in the target database if possible. |
| IgnoreDefaultCollations | idefcollate | Ignores default column collations. If a column data type is changed to non-numeric, column collations are canceled, regardless the setting. |
| IgnoreDefaultConstraints | idefault | Ignores default constraints and schema defaults. They aren’t restored after synchronization, for example, if the IDENTITY property appeared in a column to which they are related. |
| IgnoreDMLTriggerState | idmltstate | Ignores the state of DML triggers. It is preserved in the target database if possible. |
| IgnoreDropDMLTriggers | idropt | Ignores dropped DML and INSTEAD OF triggers present only in the target database when comparing and synchronizing tables or views. |
| IgnoreDropIndexes | idropi | Ignores dropped indexes present only in the target database when comparing and synchronizing tables or views. |
| IgnoreEventNotificationOnQueues | ievent | Ignores event notifications on queues during comparison and synchronization. |
| IgnoreFilegroupsPartitionSchemes | istorage | Ignores filegroups, partition schemes and functions clauses during comparison and synchronization. This option is selected by default because the tool does not synchronize the specified clauses. Instead, it synchronizes the corresponding properties of tables, indexes, primary keys, and unique constraints. |
| IgnoreForeignKeyActions | ifkacts | Ignores foreign keys actions ON UPDATE and ON DELETE. |
| IgnoreForeignKeys | ifk | Ignores foreign keys during comparison and synchronization. They aren’t restored after synchronization, for example, if a referenced column has no primary key. |
| IgnoreFullTextCatalogPath | iftpath | Ignores the path in full-text catalogs. |
| IgnoreFullTextSearch | isearch | Ignores a full-text stoplists, full-text catalogs, and full-text indexes. If these objects are altered or deleted during synchronization, they are restored if possible. |
| IgnoreIdentity | iidentity | Ignores the identity on columns. When this option is selected, the Ignore identity seed and increment values option is also applied. Identity and its seed and increment values are restored in the target database. |
| IgnoreIdentitySeedIncrementValues | iseed | Ignores the identity seed and increment values. They are preserved after synchronization. If a target column doesn’t have the IDENTITY property, it gets this property with default seed and increment values after synchronization. |
| IgnoreIndexColumnsSortOrder | iicso | Ignores the sort direction (ASC or DESC) for index columns.It is preserved in the target database. |
| IgnoreIndexes | iindex | Ignores indexes in tables and views. Indexes aren’t restored after synchronization, for example, if one of their index columns was dropped. |
| IgnoreIndexesNames | iinames | Ignores index names in tables and views. Index names are preserved in the target database. |
| IgnoreIndexPageAndRowLock | iprlock | Ignores ALLOW_PAGE_LOCKS and ALLOW_ROW_LOCKS options for indexes and constraints.These options are preserved in the target database. |
| IgnoreInsteadOfTriggers | iotrig | Ignores INSTEAD OF triggers. |
| IgnoreKeywordReduction | ired | Ignores differences in full and short names of keywords during comparison. |
| IgnoreLockEscalation | ils | Ignores LOCK_ESCALATION for tables.It is preserved in the target database. |
| IgnoreLogins | ilogin | Ignores logins, certificates, and asymmetric keys for users and synchronizes the corresponding user properties. Logins for users that exist in the target database are preserved. |
| IgnoreNextFilegroups | inextfg | Ignores subsequent filegroups. They are preserved in the target partition scheme if possible. |
| IgnoreNocheck | inocheck | Ignores a NOCHECK clause for foreign keys and check constraints.It is preserved in the target database. |
| IgnoreNotForReplication | ireplication | Ignores a NOT FOR REPLICATION option for indexes, constraints, and triggers.It is preserved in the target database if possible. |
| IgnoreNotNullConstraints | inotnull | Ignores a NOT NULL constraint for a column.The option isn’t applied to columns defined as a PRIMARY KEY constraint. |
| IgnoreObjectNamesInDefinitions | ion | Ignores object names in definitions during comparison. |
| IgnorePadIndexAndFillfactor | ipiff | Ignores PAD INDEX and FILLFACTOR options for indexes and constraints.These options are preserved in the target database. |
| IgnoreParserErrors | iparsererrors | Ignores parser errors. |
| IgnorePermissions | iperm | Ignores security permissions. Target database permissions are preserved if possible. |
| IgnorePrimaryKeys | ipk | Ignores primary keys. |
| IgnoreQuotedIdentifierAndANSINulls | iquotansi | Ignores QUOTED_IDENTIFIERS and ANSI_NULLS options for functions, procedures, or triggers.They are preserved in the target database. |
| IgnoreReplicatedProcedures | irproc | Ignores procedures created for replication. |
| IgnoreReplicatedRoles | irrole | Ignores roles created for replication. |
| IgnoreReplicatedSchemas | irschem | Ignores schemas created for replication. |
| IgnoreReplicatedTables | irept | Ignores tables created for replication. |
| IgnoreReplicationTriggers | irtrig | Ignores triggers created for replication. |
| IgnoreSemicolons | isc | Ignores semicolons in the end of statements. |
| IgnoreSensitivity | isens | Ignores metadata about the sensitivity classification of source columns. Target columns sensitivity classification metadata are preserved if possible. |
| IgnoreSequencesMaxValue | iseqmax | Ignores MAXVALUE in sequences. |
| IgnoreSequenceMin | iseqmin | Ignores MINVALUE in sequences. |
| IgnoreSequencesCache | iseqcache | Ignores CACHE in sequences. |
| IgnoreSequencesCycle | iseqcycle | Ignores CYCLE in sequences. |
| IgnoreSequencesIncrementBy | iseqinc | Ignores INCREMENT BY in sequences. |
| IgnoreSequencesInitials | iseqst | Ignores START WITH in sequences. |
| IgnoreSequencesMinValue | iseqmv | Ignores MIN VALUE in sequences. |
| IgnoreSequenceStart | iseqstart | Ignores a sequence start value. |
| IgnoreSignatures | isign | Ignores signatures when comparing and synchronizing procedures, functions, triggers, and assemblies. |
| IgnoreStatistics | istat | Ignores statistics related to a column. If it prevents the synchronization, it is dropped and then restored with default options. Statistics isn’t restored after synchronization, for example, if its column is dropped. |
| IgnoreStatisticsNorecompute | isnr | Ignores a STATISTICS_NORECOMPUTE option for indexes and constraints.It is preserved in the target database. |
| IgnoreTableDMLTriggers | itdmltrig | Ignores table DML triggers. If they prevent the synchronization, triggers are dropped and then restored. If a table is dropped, its triggers are also dropped regardless of whether the Ignore table DML triggers option is selected or not. |
| IgnoreTemporalHistoryTableName | ihistoryname | Ignores history tables names. They are preserved in the target database. |
| IgnoreTriggerFireOrder | ifire | Ignores a firing order for DDL and DML triggers. |
| IgnoreTSQLtFramework | itsqlt | Ignores the tSQLt framework and unit tests. |
| IgnoreUniqueKeys | iuk | Ignores differences in unique keys. They aren’t restored after synchronization, for example, if one of their columns was dropped. |
| IgnoreUserDefaultLanguage | iudeflang | Ignores the user-defined DEFAULT_LANGUAGE setting. |
| IgnoreUserDefaultSchema | iuds | Ignores the user-defined DEFAULT_SCHEMA setting. |
| IgnoreUserPermissions | iuperm | Ignores user permissions and role memberships. |
| IgnoreWhiteSpace | ispace | Ignores any differences in whitespaces (newlines, tabs, or spaces). |
| IgnoreWithEncryption | iwenc | Ignores differences in a WITH ENCRYPTION attribute. |
| IgnoreWithNocheck | iwnocheck | Ignores a WITH NOCHECK clause for constraints.It is preserved in the target database. |
| IgnoreWithOptionOrder | iwith | Ignores elements order in a WITH clause for views, procedures, functions, or triggers. |
| MappingIgnoreCase | micase | Ignores case in object names when mapping them. |
| MappingIgnoreSpaces | mispace | Ignores spaces in object names during mapping and comparison. |
| MappingSimilar | msim | Considers similar column names equal, for example, column1 and column1a. |
| PopulateFullTextIndexes | populate | Populates full-text indexes. |
| QuoteObjectNames | quote | Quotes object names with square brackets during script generation. |
| UserDataTypesToSystem | udttosys | Converts user data types into SQL Server system data types. |
| AddBackupType | addbt | Adds a backup type. |
| AddingErrorHandling | adderrorhandle | Adds error handling statements. |
| AddTransactionIsolationLevel | addtransiso | Sets a transaction isolation level to the selected value. This option is turned on when the Use a single transaction option is selected. The available transaction isolation levels are: SERIALIZABLE, SNAPSHOT, REPEATABLE READ, READ UNCOMMITTED, and READ COMMITTED. |
| AddWithEncryption | addwithencr | Adds a WITH ENCRYPTION clause when stored procedures, functions, views, and triggers are included in the synchronization script. |
| AddWithNocheck | addnocheck | Adds a WITH NOCHECK clause to foreign keys and constraints created during synchronization. |
| AffectedFileReadOnly | affectedfile | Removes the read-only attribute from the affected files. |
| BackupPath | backup | Creates a backup> You can specify the location of the target database backup file before synchronization. The backup file name is generated in the following format: <database_name>_<yyyy>_<MM>_<dd>_<hh>_<mm>.bak. |
| BackupExtension | extbackup | Specifies the extension for the backup file. When the option is not selected, the default extension (.bak) is used for the backup file. |
| CheckObjectExistence | cexist | Verified the object existence in the target database. |
| CommentDdlForKeysCertificates | commentkeys | Comments DDL statements for signatures, certificates, asymmetric and symmetric keys. |
| CreateBackupFolder | cbackupfolder | Creates a folder for the database backup. |
| BackupType | bt | Creates the backup in selected mode. |
| DeployDatabaseInSingleUserMode | depsingl | Synchronizes a database in the single user mode. |
| DisableDdlTriggers | noddl | Disables DDL triggers at the beginning of synchronization. After synchronization, they will be enabled. |
| DisableDependencyAnalysis | disdep | Disables database dependencies analysis. |
| DropCreateOnly | dropcreateonly | Uses DROP and CREATE instead of ALTER in a synchronization script for views, procedures, functions, or triggers. |
| DropCreateOnlyAssemblies | dropcreateonlya | Uses DROP and CREATE instead of ALTER in a synchronization script for assemblies. |
| DropCreateOnlyTables | dropcreateonlyt | Uses DROP and CREATE instead of ALTER for tables.Data is transferred to a new table. |
| ExcludeComments | nocomments | Excludes comments from the output synchronization script. |
| ExcludeDependencies | edep | Excludes dependencies. |
| ExecuteAsSingleTransaction | tran | Executes a synchronization script as a single transaction. All the changes to the database are rolled back in case of any errors during script execution. The option should be turned off when working with memory-optimized tables as execution of the ALTER, DROP, and CREATE DDL statements isn’t supported within a user transaction. |
| IncludePrintComments | iprint | Includes print comments in the deployment script. |
| IncludeUseDatabase | inud | Adds a USE <database_name> clause to the script. |
| NeedCompressBackup | comprbackup | Uses compression for a backup. This option is available for SQL Server 2008 or higher versions. |
| RefreshViews | rview | Updates the metadata for the specified schema-less view. |
| SynchronizeAsmViaFiles | asmviafiles | Synchronizes assemblies by using files. |
| UseSchemaTransfer | ust | Uses an ALTER SCHEMA TRANSFER statement to transfer tables between schemas. The option can be applied if the same database is compared. |
| VerifyTableData | verify | Verifies table data by using checksum.If any data is lost, you can see the warning in the Error List pane after synchronization. |
| IncludeIdenticalObjects | incident | Includes identical objects into the report. |
| SelectedObjectsOnly | selobjonly | Includes objects selected for synchronization into the report. |
The table describes comparison report options.
| Full name | Short name | Description |
|---|---|---|
| AppendTimestampReport | tsreport | Generates a comparison report with a timestamp. |
| IncludeComparisonSettings | incsettings | Includes comparison options into the report. This option is available only for HTML reports. |
| IncludeSyncScript | incscript | Includes a synchronization script into the report. |
| IncludeSyncWarnings | incwarnings | Includes synchronization warnings into the report. |