How to sync only some parts of your tables (constraints, indexes)?

SQL Examiner offers a Partial Synchronization mode that allows developers to drill down to select specific objects within a table for a more fine grained comparison.

You can switch to the Partial Synchronization mode, if you need to manually manage the synchronization of the following objects: columns, constraints, triggers, indexes, statistics, permissions, extended properties, settings of full-text search.

To switch to the Partial Synchronization mode, select the appropriate item from the Full synchronization/Partial synchronization drop-down list in the toolbar.

You can expand a node of the database object tree:

Now you can choose to synchronize the entire object or its parts. For example, if you synchronize a table, and don’t want to transfer a trigger to the target database, check the appropriate node of the table and uncheck the trigger.

By default, the SQL1 tab displays the synchronization script for the entire object (see the prompt in the information bar above the tab). But you can choose to display the synchronization script for selected objects only by checking the appropriate box.

Now the code window doesn’t show script strings with statements to synchronize the trigger.

The Show synchronization script for selected differences only/Show synchronization script for entire object modes affect the way the script is displayed in the main window, they are not connected with the synchronization process itself. No matter which of the modes is on, the script will synchronize the selected details of the chosen objects.

When the Partial Synchronization mode is on, the status bar reports differences of any selected object: even if it is a column, a trigger or an index. So you can receive detailed comparison results for a column of a table existing in both databases when it is impossible to notice any differences with a brief survey.