Updating cloned tables from the command line

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.