Promote
Packages
Use this page to
- Add Filters to Packages
- Create a Package
- Copy an Existing Package
- Create Package Template Groups and Package Templates
- Compare Code Across Environments
- Create Databases That Do Not Exist in the Destination
- Manually Add Objects
- Manually Ignore Objects
- Queue Data to be Transported
- Queue SQL Objects to be Transported
- Resolve an INNER/OUTER Naming Issue
- Review Data to Decide What to Transport
- Transport Queued Records
- View Logs
- Click Packages in the Navigation pane.
-
Click the Packages icon for a Package Group.
OR
- Click Approval in the Navigation pane.
- Click the View Packages icon for a package group approval request.
|
Field |
Description |
|
Compare |
Click to compare one environment to another. This process runs in the background. Hold Ctrl to select multiple packages to compare. Once the compare process has finished running, underlining pages for the Data (total number of tables) and SQL Objects (total number of objects) icons are populated. |
|
DESTINATION ID |
Displays the data source for the destination (target) server. This list is controlled on the Servers page. |
|
PRIORITY |
Displays the order in which the packages are transported to the destination server. |
|
NAME |
Displays the name of the package. |
|
Data |
Click to open the Package - Data Comparison page to view the comparison of data in the tables between the two environments. The count on the icon displays the number of records marked to be transported. |
|
SQL Objects |
Click to open the Package - Object Comparison - Per Database page to view the comparison of the schema between the two environments. The count on the icon displays the number of SQL objects in the queue to be transported. |
|
Databases |
Click to open the Package - Databases page to create databases that are not in the destination system. Refer to Create Databases That Do Not Exist on the Destination for more information. |
|
Transport |
Click to move the selected table data and SQL objects from the host server to the destination server. |
|
Log |
Click to open the Package - Messages page to view everything happening during the transport process. Refer to View Logs for more information. |
|
LAST RUN |
Displays process that ran (either Compare or Transport), and the date and time it last ran. |
Packages V (All Tabs)
This page contains the following tabs:
General tab
Use this tab to:
|
Field |
Description |
|
Name |
Displays the name of the package. |
|
Description |
Displays a brief description of the package. |
|
Destination ID |
Displays the data source for the destination server. This list is controlled on the Servers page. |
|
Fix INNER/OUTER Naming Issue |
Click to resolve an Inner/Outer naming issue on the Log (i.e., the Package - Messages page). This feature drops and re-creates the view to resolve the issue. After running this process, click the Compare icon to run the compare process again. |
|
Copy Package |
Click to create a duplicate of the package within the current Package Group. This process is helpful when creating similar packages or troubleshooting a primary key error. Refer to Copy Existing Package for more information. |
|
Pack Documentation |
Click to open the Package - Documentation page to upload documentation or instructions on how to execute the package and/or code transport. |
Data Structure tab
Use this tab to Add Structure Data Filters.
|
Field |
Description |
|
Structure Data ID |
Displays the name of the selected Structure - Data item that is used in the package. |
|
Structure Data Focus |
Displays a list of tables associated with the selected Structure Data. Users can select at which level within the structure on which they want to base the comparison or the transport process. |
|
Structure Data Focus_Simple Field |
Displays columns that have Simple Selection checked in the configuration for the data structure table (on the Structures - Data Table Columns page). This field allows for easily filtering of the columns marked for Simple Selection. Refer to Use a Simple Selection List for more information. |
|
Structure Data Focus_Simple Value |
Displays the Simple Selection value on which to filter. Only records defined by the filter for that single value are included in the compare process. Refer to Use a Simple Selection List for more information. |
|
Structure Data Focus_Adv Where Clause |
Displays a WHERE clause used to filter out specific data from the view in order to add granularity to the compare process. |
|
Additional Filtering |
|
|
Structure Add Filter1_Data Focus |
Displays a list of tables associated with the structure. Users can add secondary filters to tables lower down the structure to further reduce selection of records for comparison. Refer to Use Additional Filters for more information. |
|
Structure Add Filter1_Simple Field |
Displays columns that have Simple Selection checked in the configuration for the data structure table (on the Structures - Data Table Columns page). This field allows for easily filtering of the columns marked for Simple Selection. |
|
Structure Add Filter1_Simple Value |
Displays the Simple Selection value on which to filter. Only records defined by the filter for that single object are included in the compare process. |
|
Structure Add Filter1_Adv Where Clause |
Displays a WHERE clause used to filter out specific data from the view in order to add granularity to the compare process. |
|
Structure Add Filter2_Data Focus |
Displays a list of tables associated with the structure. Users can add secondary filters to tables lower down the structure to further reduce selection of records for comparison. Refer to Use Additional Filters for more information. |
|
Structure Add Filter2_Simple Field |
Displays columns that have Simple Selection checked in the configuration for the data structure table (on the Structures - Data Table Columns page). This field allows for easily filtering of the columns marked for Simple Selection. |
|
Structure Add Filter2_Simple Value |
Displays the Simple Selection value on which to filter. Only records defined by the filter for that single object are included in the compare process. |
|
Structure Add Filter2_Adv Where Clause |
Displays a WHERE clause used to filter out specific data from the view in order to add granularity to the compare process. |
Object Structure tab
Use this tab to Add Structure Object Filters.
|
Field |
Description |
|
Structure Object ID |
Displays the object to be used to filter objects for the compare process. |
|
Structure Object Where Clause |
Displays a WHERE clause used to filter out specific SQL objects in order to add granularity to the compare process. |
Manual Objects tab
Use this tab to:
|
Field |
Description |
|
Manual Add Objects |
Click to open the Package - Manual Object page to manually add objects that may be needed for the package. Refer to Manually Add Objects for more information. |
|
Manual Ignore Objects |
Click to open the Package - Manual Ignore Object page to manually add objects to be ignored during the transport process. Refer to Manually Ignore Objects for more information. |
