Skip to main content

Table of Contents

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


Only available versions of this content are shown in the dropdown

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 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. 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. If you use a split schema, the value for the data schema name.

  2. Configure the Generate DDL properties of the 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 file.

  4. Run the prpcUtils.bat or script with the generateDDL option, for example:

    prpcUtils.bat generateDDL
  5. Give the DDL file to the database administrator to apply to your database.

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us