SQL Compare - 10.2

SQL Compare

Setting up the deployment - SQL Compare

When you have reviewed the comparison results, you can run the Deployment wizard to create the SQL script to deploy the selected objects:

  1. Select the objects that you want to deploy.
  2. Click  Deployment Wizard to start the Deployment wizard.

Selecting the objects to deploy

By default, no objects are selected for deployment. You can modify the selection by using the check boxes in the middle of the upper (Results) pane:

Object selections are remembered when you save a project.

To select all the objects in a group for deployment, select the check box on the grouping bar for that group; alternatively, you can right-click within the group and click Include All Objects in this Group.

To exclude all objects displayed in a group from the deployment, clear the check box; or, you can right-click the group and click Exclude All Objects in this Group.

The top level check box in the central column enables you to include or exclude all objects that are displayed in the upper (Results) pane:

You can filter the object types and use the Find box to assist you with your selection.

Note that if you select an object for deployment and then set up a filter that excludes that object type, the object is not included in the deployment. Only selected objects that are shown in the comparison results are included.

For example, if you select TableA for deployment, and then set up a filter to exclude all tables, no tables are shown. If you subsequently remove the filter, TableA is displayed and remains selected for deployment.

Example: Selecting objects that exist only in the source

  1. In the Filter pane, to the left of the results, ensure that the default filter Nothing Excluded is selected, so that all the objects are displayed in the upper (Results) pane.

    No objects are now excluded by the filter.

  2. Ensure the top level check box in the central column is cleared, or on the Actions menu select Exclude All.

    No objects are now selected for deployment.

  3. From the Group by box, select Type of difference if it is not already selected. On the grouping bar for objects that exist only in <source database name>, select the check box to include all of the objects in this group.

Example: Selecting only stored procedures

  1. From the Group by box, select Type of difference if it is not already selected.

    The objects are now grouped by whether they are different, identical, or present in only one of the data sources.

  2. In the Filter pane, select and clear the All object types included check box, and then select the check box for Stored Procedures.

    Only Stored Procedures are now displayed in the upper pane.

  3. Select the top level check box in the central column to include all objects in the deployment.

Example: Selecting only tables that exist in both databases but are different

  1. From the Group by box, select Type of difference if it is not already selected.

    The objects are now grouped by whether they are different, identical, or present in only one of the data sources.

  2. In the Filter pane, clear the All object types included check box, and then select the check box for Tables.

    Only Tables are now displayed in the upper pane.

  3. Clear the top level check box in the central column to exclude all objects from the deployment.

    No objects are now selected for deployment.

  4. On the grouping bar for objects that exist in both but are different, select the check box to include all of the tables in this group in the deployment.

See also

Using the Deployment wizard

Viewing the comparison results

Understanding the deployment

Using filters

Was this article helpful?

Search support
Forums
Visit the SQL Compare forum.
Learning SQL Compare
Knowledge base

SQL Compare

all SQL products

all products

Notes & articles

SQL Compare

all SQL products

all products

Demos & walkthroughs

SQL Compare