The export date, the export description, database revision and the name of the export file in the source database transport history are recorded when a transport package is created with the Database Transporter.
When you import a transport package with the Database Transporter, the import date and description, the database version, and the transport package name are recorded in the transport history of the target database.
To display transport history
You create transport packages to exchange customer-specific changes between the development, test, and productive system databases.
To create a transport package
-
Start the Launchpad and log in to the One Identity Manager database.
-
In the Change & Extend view, select the Transport custom modifications entry and click Start.
This starts the Database Transporter program.
-
Select Create a transport file on the start page.
-
On the Select the database connection page, check the One Identity Manager database connection data and change it if necessary.
-
Enter the information about the transport file on the Define file name page.
-
Enter the name of the transport file and change the output directory as required.
-
(Optional) To create a log file for the export, set the Create a log file for data export option.
The log file is saved in the output directory of the transport file.
-
(Optional) To remove sensitive data from the transport, enable the Create an anonymized transport option.
For example, this will remove information about the database server, the database, and users.
-
Enter a description of the transport data on the Show and define transport parameters page.
-
Select the export criteria for the transport on the Define transport data page.
NOTE: You can combine multiple export criteria.
Table 37: Export criteria
|
Run SQL statements before data import |
You can integrate SQL statements in the custom configuration package, which are to be run before a data import.
For more information, see Integrating SQL statements in transport packages. |
|
Transport of favorite objects |
In an initial selection, all modified processes, scripts, reports, and mail templates for a specific timeframe are offered.
For more information, see Exporting favorite objects. |
|
Transport by change label |
Transport the changes to objects or object attributes that are summarized in a change label.
For more information, see Exporting change labels. |
|
Transport by change information |
Limit the transportation data by user, timeframe, and database tables.
For more information, see Exporting changes based on change information. |
|
Transport schema extensions |
Transport custom schema extensions, such as tables, columns, database procedures, functions, triggers, views, and indexes.
For more information, see Transporting schema extensions. |
|
Transporting selected objects and their dependencies |
Select single objects and their dependencies for transport.
For more information, see Exporting selected objects and dependencies. |
|
Transport system configuration |
Transport the entire system configuration.
For more information, see Exporting the entire system configuration and Tips for importing the system configuration. |
|
Transport the system configuration as delta transport |
Find the differences in the configuration and create a delta transport.
For more information, see Exporting system configurations as delta transports and Tips for importing the system configuration. |
|
Transport system files |
Transport single files.
For more information, see Exporting system files. |
|
Create cumulative transport |
You can group together several custom configuration packages into one cumulative transport package.
For more information, see Creating cumulative transports. |
|
Transport synchronization projects |
Select the synchronization project for transporting.
For more information, see the One Identity Manager Target System Synchronization Reference Guide. |
|
Run SQL statements after the data import |
You can integrate SQL statements in the custom configuration package, which are to be run after a data import.
For more information, see Integrating SQL statements in transport packages. |
|
Use a transport template for selection |
Select a transport template for the transport. The export criteria are determined from the transport template.
For more information, see Creating and using transport templates. |
-
To start the export, click Next.
This create the transport package. The program determines the data to export and displays the progress of the export in the dialog. The export procedure can take some time.
-
On the last page, the name and storage path for the transport package are displayed. You can open the directory path using the link.
-
To end the program, click Finish on the last page.
Related topics
You can integrate SQL statements in the custom configuration package. The SQL statements are run before or after a data import. For example, after a schema extension has been transported an SQL statement may be required for filling initial data in the new columns.
NOTE: To create transport packages with SQL statements, users require the Transport_SQL program function.
To run SQL statements within a transport package
-
In the Database Transporter, on the Define transport data page, select the export criteria for running SQL expressions. The following export criteria are available:
-
Create the SQL statement using the Edit button. Differentiate between SQL statements for system data transport and user data transport.
-
Enter the SQL statement directly.
- OR -
Use the 
button to load a .sql file that contains the statements.
-
Use the 
button to save to a file.
-
(Optional) Enable the Ensure single user mode for importing option.
Related topics
Use the Transport favorite objects transport method to select the modified processes, scripts, reports, and mail templates from a specific timeframe.
To transport favorite objects
-
In the Database Transporter, on the Define transport data page, select the Transport favorite objects export criteria.
-
Click Select to select the single objects for the transport.
-
In the Object modified in last ... days input field, enter the timeframe for the object selection.
All objects with a change date and user in the selected timeframe are displayed.
TIP: To include other processes, scripts, reports, or mail templates in the transport package, use the Load all entry.
-
Select the object you want and use 
to add it to the transport package.
TIP: Use Shift + select or Ctrl + select to select multiple objects in the selection dialog.
The Objects to transport pane lists all selected objects and their dependencies.
Related topics
