Help for SQL Delta

Schema Compare Results

Once the source and target schema have loaded and compared the Schema Compare tab is updated displaying the comparison results.

To generate a deployment synchronize script click the Script Button or press F9.

Once the schema has been compared any underlying changes to the schema are not displayed until the compare is re-run by either pressing refresh or re-running the project from edit project.

The Display Options configures how the results are displayed and grouped with 3 display grouping options.

None, Objects are not grouped and are sorted on a default object type basis with Tables first, then Views and so on. Sorting of results affects the entire result set.
By Object type. In this style a group bar is shown identifying the group, the object type such as Tables and below the group bar are the set of tables displayed in alphabetical order.
By Difference type. In this style a group bar is shown identifying the difference group and below all of the objects within that difference group.

When the results are grouped all groups can be expanded or contracted by clicking the all groups button.
Script generates a Schema Compare Deployment Script in a new tab, this script synchronizes your target database to have the same objects as the source.
The name of the project
Reload the source and target schema and re-compare.
Print summary or detail schema difference reports. See Schema Compare Reports for details on the reports.
Generate a source or target Snapshot using the existing loaded schema from source or target respectively.
Open the project for editing in a new edit tab and switch to the edit tab. Any changes within edit require a refresh to force the project details to be reloaded for the compare.
Check or de-check all differences in the results. If objects have been filtered out from the display then their checked state will not be affected.
By default the script generator automatically adds dependent objects into the script list. For example View A is the only object selected for scripting and is dependent on Table A which also has changes. Table A will be automatically included in the script generation because of the dependency. When No Depend is pressed the script generator does add dependent objects. See Dependency for more details about dependent actions.
By default the script generator will not automatically add objects to be dropped, these must be manually selected. Clicking Allow Drop will allow dependent drops to be automatically added.
Change the scripting direction to generate the update script from target to source instead of the default source to target. We recommend scripting source to target or changing the project to create a new source/target to reduce the risk of accidentally updating an unintended database.
Display Options configures how the results are displayed.
Filters provide a comprehensive method of filtering the compare results. These filters can be persisted with the project so each time you run the compare the filter will be applied when the results are displayed.
Quick Filter or Find. Enter text and press enter or click the filter button (marked as P) to generate a text filter across all results. Alternatively click the next/previous buttons (marked as Q) to find the next or previous instance of an object containing the search text in the name.
Quick difference type filters to exclude In Source, Different, In Target or Equal results. The total number of objects matching the difference type is also shown in the filter buttons.
Combined with filter (marked as N) this adds a quick text filter for the compare results
These two buttons along with the filter text search forwards or backwards for object that contain the search text.