LinkedIn
Copied!

Table of Contents

Applying database schema changes

Version:

Only available versions of this content are shown in the dropdown

If a hotfix package includes database schema changes, you can choose whether to apply the schema with the other hotfix changes or in a separate step. If you choose a separate step, you can generate an SQL script so that a database administrator can review the changes and manually apply them to the database.

If you do not manually apply these SQL changes, the hotfix installation process applies them.

Your database administrator can use the SQL script to apply the database changes manually.

  • Creating an SQL script from the user interface

    If a hotfix requires schema changes and you want to apply them manually, you can generate an SQL script from the user interface. Your database administrator can use this script to manually apply the schema changes.

  • Creating an SQL script by submitting a request to an active instance

    If a hotfix requires schema changes and you want to apply them manually, you can generate an SQL script by invoking a web service to connect to an active instance of Pega Platform. Your database administrator can use this script to manually apply the schema changes.

  • Creating an SQL script by using a direct connection to the database

    If a hotfix requires schema changes and you want to apply them manually, you can generate an SQL script by connecting to the database. This is most commonly done for a stopped instance. Your database administrator can use this script to manually apply the schema changes.

Have a question? Get answers now.

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