SQLDiff Result Page

When comparison is done, you will see the result in the SQLDiff Page.

• Deployment Wizard – Starts wizard that tunes and performs deployment.
• Filters – Customize the view of synchronization actions.
• The Object Tree (top left) - Displays the different objects.
• The Action List (middle) - Displays the list of actions to sync of selected object or set of objects.
• The SQL Panel (bottom) - Displays the SQL scripts for selected action(s).

• Save (toolbar) – Saves changes or creates new SQLDiff project

Using filters you can change content of the list of actions.

	Disable filters
	Show only selected objects.
	Show actions for objects that should be added to the Source DB.
	Show actions for objects that should be changed in the Source DB.
	Show actions for objects that should be removed from the Source DB.

In the script panel you can see and Edit the Diff script(s) for particular action.

• Synchronisation – Shows the script to synchronise Source object with Destination.
• Rollback – Shows the script to rollback changes of synchronisation.
• Apply – Saves changes in the script.
• Discard – Rollbacks all custom changes for particular script.

The “Save Script” button invokes menu for saving script:

• Synchronisation…“ – Invokes dialog to save the Synchronisation script.
• Rollback…“ – Invokes dialog to save the Rollback script.

• Add Header – Adds a custom script to the head of sync script from the file.
• Add Footer – Adds a custom script to the end of sync script from the file.

• Save To File… – Opens the system dialog to save the sync script to the file.
• Copy to Clipboard – Copies the sync script to the clipboard.

The “Synchronize…” button inn the tool-bar invokes the wizard for sync databases.

At the first page you can tune a synchronization process:

• Set synchronization mode - synchronize databases by one script for all objects, by one script for each group of objects or by one script for each different object.
• Select post synchronization action.
• Add custom preprocessing and postprocessing scripts.

At the last page you can see a process of the synchronization.