Promote

Review Data to Decide What to Transport

Depending on the project, processes may yield that everything is moved every time. Or, projects may want to analyze the comparison logs and determine individual items to promote.

Users can review the results of the comparison to identify:

  • data in the host server, but not in the destination server

  • data in the destination server, but not in the host server

  • records that exist on both the host and the destination server, but have different values for the columns

  • same records on the host and destination server with no differences

By adding data to the queue, data is included in the transport.

To review data to decide what to transport:

  1. Select Package Groups in the Navigation pane.

  2. Click the Packages icon for a package group.

  3. Click the Data icon to review table data records.

    OR

    Click the SQL Objects icon to review SQL object records.