Generating a DDL file of schema changes that are referenced from an archive file

The import process can apply those schema changes from an archive automatically, or you can generate a DDL file of schema changes from the command line and apply the changes manually.

1. Configure the common properties of the prpcUtils.properties file.

   Property name	Value
   pega.jdbc.driver.jar	Path to the database driver .jar file.
   pega.jdbc.driver.class	The database driver class.
   pega.database.type	Database vendor type.
   pega.jdbc.url	URL of your database.
   pega.jdbc.username	Database user name.
   pega.jdbc.password	Database password.
   rules.schema.name	If you use a split schema, the value for the rules schema name. If you do not use a split schema, the value for the schema name.
   data.schema.name	If you use a split schema, the value for the data schema name.

2. Configure the Generate DDL properties of the prpcUtils.properties file.

   Property name	Value
   schema.archive.input	The full path to the archive file that contains the schema definition. To specify multiple input files and generate multiple DDL files, use commas to delimit the list.
   schema.generated.output	The full path to the output directory for the DDL files. For example, C:/Output.

3. Save and close the prpcUtils.properties file.
4. Run the prpcUtils.bat or prpcUtils.sh script with the generateDDL option, for example:
   prpcUtils.bat generateDDL
5. Give the DDL file to the database administrator to apply to your database.