LinkedIn
Copied!

Table of Contents

Updating cloned tables from the command line

Version:

Only available versions of this content are shown in the dropdown

You can use the Upgrade Applications Schema utility from the command line to update cloned rule, data, work, and history tables with the schema changes in the latest base tables.

  1. In the Pega-image \scripts\utils\ directory, open the prpcUtils.properties file in a text editor.

  2. Specify how to apply the changes:

    • To apply the changes automatically, set:
      upgrade.applications.schema.operation=apply
    • To download SQL files of schema changes for your database administrator to apply:
      1. Set the operation:
        upgrade.applications.schema.operation=download
      2. Optional: Specify the output directory. The default directory is C:/Output/.

        upgrade.applications.schema.generated.output=
        my-output-directory
  3. Save and close the file.

  4. Run the prpcUtils.bat or prpcUtils.sh script.

  5. If you downloaded SQL files of changes, give the outputschema.zip file of SQL changes to your database administrator to apply.

Have a question? Get answers now.

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