Several changes to objects or objects properties are grouped together under a change label and can be swapped between source database and target database in this way. When a custom configuration package is imported with change labels, new data records are added to the target database and existing data records are updated. In addition, objects marked for deletion in the change label are deleted from the target database.
NOTE: There are no change labels available after initial schema installation.
To transport by change label
-
In the Database Transporter, on the Define transport data page, select the Transport by change information export criteria.
-
Select the change label from the menu.
-
(Optional) To display the contents of a change label, click Display.
Objects and changes are displayed, which belong to the change label.
NOTE: If a change label still contains references to objects that no longer exist in the database, remove the assignment using the Repair button.
-
(Optional) For additional settings for change label transport, click Options and specify the following options.
Table 38: Additional transport settings
|
Close change label after export |
The change label is completed and locked after transport. No more changes can be booked to this change label. |
|
Copy dependent objects to the transport package |
Objects that are dependent on the selected object and do not have a change label are also copied to the transport. |
|
Also display closed change labels |
Change labels that are already closed are also offered for selection. |
Related topics
Use the Transport by change information transport method to limit transportation data by user, time period and database tables.
To transport by change information
-
In the Database Transporter, on the Define transport data page, select the Transport by change information export criteria.
-
Specify which changes you want to transport.
Table 39: User list
|
me |
Only the changes by the logged-in user are added. |
|
all users |
Changes are added from all users. |
|
selected users |
Changes are added from selected users.
TIP: The User area displays the system users. The ... button beside the input field allows you to select other users. Use Shift + select or Ctrl + select to select multiple users in the selection dialog. |
-
Use the date filter to export changes for the selected user(s) from a specified date. The entries today, yesterday, day before yesterday, this week and last database migration and time period are available.
- You can limit transportation data even further by selecting database tables.
-
Table 40: Table selection
|
Entire system |
Changes are added from all tables. |
|
System data |
Changes are added from the tables of the system data part. |
|
User data |
Changes are added from the tables of the user data part. |
|
Selected tables |
Changes are added from specific tables. |
TIP: To display objects that match the specified export criteria, click Display. In this overview, you can exclude individual objects from the transport To do this, disable the corresponding objects.
Related topics
Custom schema extensions, like tables, columns, database procedures, functions, triggers, views, and indexes that you want to add, must distinguished by a custom prefix CCC_. Furthermore, only custom database procedures, functions, triggers, views, and indexes that are not encoded and are smaller than 64 kb are included.
Custom database procedures, functions, triggers, and views are always exported in their entirety. Entries corresponding to custom tables and columns are generated in the One Identity Manager schema when the transport package is imported (tables DialogTable, DialogColumn, QBMRelation).
To transport all schema extensions completely from a test database to a productive database, the following procedure is recommended:
-
Create a transport of schema extensions in the test database and import these into the production database.
-
Create a transport of the system configuration in the test database and import these into the production database.
Use the transport options to transport single customizations by change label, change information or selected objects.
To transport schema extensions
NOTE: Use Show to display the schema extensions.
Related topics
Use the Transport selected objects and dependencies transport method to select individual objects and their dependencies to transport. You can add objects dependent on the object you want to transport without having to select them individually.
NOTE: The selection for this transport criterion displays all tables not labeled with the No DB Transport option. If objects of other tables are to be transportable, then disable the option for the tables in the Designer. For more information about customizing table definitions, see the One Identity Manager Configuration Guide.
To transport single objects and their dependencies
-
In the Database Transporter, on the Define transport data page, select the Transport of selected objects and dependencies export criteria.
-
Click the Select button to select the single objects for the transport.
-
In the Tables pane, select the database table from which you want to copy objects to the custom configuration package.
-
The Relations pane displays the ChildRelation (CR), ForeignKey (FK) and many-to-many relations for the selected database table. Enable the required relations to copy the connected objects to the transport.
-
The Objects pane displays all the objects of the selected table. Select the objects you want and add them to the transport.
-
To delete superfluous objects when the transport package is imported, select 
.
-
If you do not want to perform post-processing when the transport package is imported, select 
.
-
The Objects to transport pane lists all selected objects and their dependencies.
TIP: To remove individual object from the transport, select Remove.
Related topics
to create a filter to limit the selection.