Switch to: V10V9V8V7V6V5

SQLDiff Result Page

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

SQLDiff Help - Page with Results

  • 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

Filtering Result

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.

Difference Script

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

SQLDiff - Synchronisation script SQLDiff - Rollback script

  • 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.

Saving the Sync Script

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

SQLDiff - Save Script Menu

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

SQLDiff - Save Script Dialog

  • 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.

Synchronize Databases

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.

SQLDiff - Sync Dialog: Settings

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

SQLDiff - Sync Dialog: Execution