Integrating SQL statements in transport packages
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 a SQL statement may be required for filling initial data in the new columns.
NOTE: To create transport packages with SQL statements, users need the Enables integration of SQL statements in a transport file (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.
Related topics
Exporting favorite objects
Use this 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 of 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
Exporting change labels
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
Exporting changes based on change information
Use transport by change information 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