Promote

Transport Queued Records

Verify if all queued records need to be transported. If approval mode is enabled, package groups cannot be transported until an approver reviews the queued data and SQL objects and approves the request.

Databases that are exclusively used by the Stewardship Tier are protected, which means they are always excluded from the transport process. This feature prevents SQL objects from being overwritten.

Transport Packages

To transport a package:

  1. Select Packages in the Navigation pane.

  2. Click the Packages icon for a package group.

  3. Click the Transport icon; the selected objects and schema are moved from the host server to the destination server.

NOTE: Promote attempts to create the SQL objects in the order of their dependencies. In some cases, complex SQL relationships may cause transport failures meaning the comparison and transport process needs to be run multiple times.

  1. View logs to see if any additional action needs to be taken.

Transport Individual SQL Objects

To transport an individual SQL object:

  1. Select Package Groups in the Navigation pane.

  2. Click the Packages icon for a package group.

  3. Click the SQL Objects icon for a package.

  4. Click one of the following links, depending on what comparison result is being transported:

  • NOT IN DEST— Displays the database, and active SQL objects and their dependencies that exist on the host server, but not on the destination server.

  • DIFFERENT— Displays the database, and active SQL objects and their dependencies that exist on both the host and the destination servers, but have different values for columns that are being compared.

  • SAME— Displays the database, and active SQL objects and their dependencies that exist on the host and the destination servers and there are no differences between the SQL objects that are being compared.

  • QUEUE— Displays the database, and active SQL objects that have been selected to be transported to the destination server.

  • ALL— Displays all databases and corresponding SQL objects.

  1. Click the Transport icon to promote the individual SQL object.

  2. View logs to see if any additional action needs to be taken.