Promote

Queue SQL Objects to be Transported

Promote has the granularity to move entire databases or specific SQL objects and their dependencies. Databases can be protected, which means they will never be moved, even if differences are detected.

Many Syniti solutions are driven by views, stored procedures, functions and tables. Any given project could have 100s or 1000s of these SQL objects. The comparison process identifies for a given database what the object is and what is different or the same. In Promote, users can see the items side-by-side.

By default, all SQL objects that do not exist in the destination or are different between the host and destination are queued, with the exception of the following:

  • Views pointing to tables in dgSAP* database

  • SQL objects that have been manually excluded from the package

  • Auto Ignore Objects

Either decide to queue the change, or if the object is a table, enable the KEEP DEST DATA check box on the Package - Object Comparison page to create/recreate the table in the destination while keeping the data that already exists in the destination.

 

To select which SQL objects are queued for transport:

  1. Select Packages on the Navigation pane.

  2. Click the Packages icon for the package group.

  3. Click the SQL Objects icon for the package.

  4. Click one of the hyperlinks:

  • NOT IN DEST—Displays tables that exist on the host server, but not on the destination server.

  • DIFFERENT—Displays tables that exist on both the host and the destination servers, but have different values for columns that are being compared.

  • SAME—Displays tables that exist on the host and the destination servers, and there are no differences between the columns that are being compared.

  • QUEUE— Displays all tables that have been selected to be transported.

  • ALL— Displays all records on the selected table.

  1. Use the toolbar icons Send All Objects (i.e., transport everything) and Ignore All Objects (i.e., exclude everything) to select what is included in the promotion.

    Or

    Click the Send Toggle icon to select (or unselect) an individual record for transportation.

NOTE: To view the SQL differences side by side, click the Compare SQL icon.

To queue all SQL object differences after making change:

  1. Select Packages on the Navigation pane.

  2. Click the Packages icon for the package group.

  3. Click the SQL Objects icon for the package.

  4. Click the Queue Diff icon for a line item; all differences (Not in Host, Not in Destination and Different) are queued to be transported.