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:
-
Run SQL statements before data import
-
Run SQL statements after the data import
-
-
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.
-
to add it to the transport package.