dbForge Studio for PostgreSQL lets you configure command-line options in the New Schema Comparison wizard and save them to a .txt file.
You can also use the /options parameter to specify options from the command line by using the full or short option name and its value.
dbforgepostgresql.com /schemacompare [/option_name1[:value | [parameter1:value parameter2:value ..]] /option_name2 ..]
To turn an option on, specify: Yes, Y, On, True, or T.
To turn an 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 database properties in comparison and synchronization. Note: If the database object depends on other objects selected for synchronization, it is still synchronized even when the Compare database properties option is turned off. |
| ExcludeComments | nocomments | Excludes comments from the synchronization script. |
| ExecuteAsSingleTransaction | tran | Executes a synchronization script as a single transaction. If an error occurs during execution, all changes to the database are rolled back. |
| ForceColumnOrder | force | Recreates the table when new columns are added to preserve column order. If this option is turned off, differences in column order are ignored, and the objects are treated as equal. |
| IgnoreCase | icase | Ignores case differences in the object body during comparison. Objects that differ only by letter case are treated as equal in the comparison results. |
| IgnoreColumnDefaultValues | icolumndef | Ignores column default values during comparison and synchronization. |
| IgnoreComments | icomment | Ignores comments when comparing stored procedures or functions. During synchronization, comments in the object definition are preserved. |
| IgnoreConstraintsNames | icnames | Ignores constraint names during comparison and synchronization. |
| IgnoreDatabaseLevelRoleParameters | idbroleprm | Ignores database-level role parameters during comparison and synchronization. This option helps you prevent errors caused by missing roles on the target server. |
| IgnoreDatabaseObjectOwners | ioowner | Ignores database owners and database-contained object owners during comparison and synchronization. Target owners are preserved when possible. |
| IgnoreDataTypesInColumn | idtc | Ignores column data types during comparison and synchronization. The column data types are preserved in the target tables when possible. |
| IgnoreForeignKeys | ifk | Ignores foreign keys during comparison and synchronization. Foreign keys might not be restored after synchronization, for example, if a referenced column does not have a primary key. |
| IgnorePermissions | iperm | Ignores security permissions during comparison and synchronization. Target database permissions are preserved when possible. |
| IgnoreSequencesCache | iseqcache | Ignores the CACHE clause in sequences. |
| IgnoreSequencesCycle | iseqcycle | Ignores the CYCLE clause in sequences. |
| IgnoreSequencesIncrementBy | iseqinc | Ignores the INCREMENT BY clause in sequences. |
| IgnoreSequencesInitials | iseqst | Ignores the START WITH clause in sequences. |
| IgnoreSequencesMaxValue | iseqmxv | Ignores the MAXVALUE clause in sequences. |
| IgnoreSequencesMinValue | iseqmv | Ignores the MINVALUE clause in sequences. |
| IgnoreWhiteSpace | ispaces | Ignores white spaces, such as new lines, tabs, or spaces, during comparison. Original white spaces in the scripts for database objects and computed columns are preserved. |
| MappingIgnoreCase | micase | Ignores case differences in object names during mapping. |
| MappingIgnoreSpaces | mispace | Ignores spaces in object names during mapping and comparison. |
| MappingSimilar | msim | Treats similar column names as equal, for example, column1 and column1a. |
| UseSchemaNamePrefix | fullnames | Generates fully qualified object names in the synchronization script. When the option is turned on, object names include the schema name. |
The following table describes comparison report options.
| Full name | Short name | Description |
|---|---|---|
| AppendTimestampReport | tsreport | Generates a comparison report with a timestamp. |
| IncludeSyncScript | incscript | Includes a synchronization script in the report. |
| IncludeSyncWarnings | incwarnings | Includes synchronization warnings in the report. |