Question


The Bank of Nova Scotia
CA
Last activity: 1 Apr 2025 9:40 EDT
Pega upgrade - what it does internally ?
Hi All, Anyone aware what exactly Pega upgrade scripts does at the backend in both full upgrade and data only upgrades ?
Like what tables it touches, what modifications it does to DB etc ?
Looking at the upgrade logs, it seems its trying to add more columns to existing tables.
-
Reply
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Accepted Solution
Updated: 1 Apr 2025 9:40 EDT


Pegasystems Inc.
IN
If you are looking into changes in database , like changes to table, columns etc, then you can generate the upgrade DDLs first.
In upgrade bundle, in scripts folder, there is a file generateDDL. You can execute it by passing right parameters, which will generate the DDLs which can be applied manually before executing the upgrade.
Changes are specific to per client environment.
Thanks
Suhas


Pegasystems Inc.
GB
are you able to access the MSP GenAI Buddy? Please see if the answer helps you.
https://support.pega.com/support-doc/using-pega-genai-knowledge-buddies
https://support.pega.com/support-doc/my-support-portal-home-page
References:
https://support.pega.com/discussion/automatic-upgrade-custom-db-tables-done-pegas-upgrade-script
https://support.pega.com/question/upgradeupdate-pega-data-schema


The Bank of Nova Scotia
CA
@MarijeSchillern I have gone through those results, but those aren't comprehensive. I'm looking for list of tables and modifications on those (high level) for full and data only upgrades please. Especially Pega 7 to Pega 8 upgrades.
Any help would be highly appreciated.


The Bank of Nova Scotia
CA
@KiranU8720 Any update on this please ?


Pegasystems Inc.
GB
@KiranU8720 if you need to discuss this in-depth I would suggest that you request consultancy help via your Pega AE.
@PrakashKaragi @mekad @SuhasKumar is this quesion something the Modernization team could help with?


HCA Healthcare
US
In a Pega upgrade, whether it's a full upgrade or a data-only upgrade, the system modifies the underlying database to ensure compatibility with the new version. During a full upgrade, Pega updates both the application code and database schema, which may involve adding new columns to existing tables, modifying data types, or introducing new tables to support enhanced features. This is done through upgrade scripts that adjust the structure of the database. In a data-only upgrade, the changes are focused on migrating data without affecting the application logic, but it might still add or modify certain fields to support new functionalities or improvements. The logs typically show these changes as additional columns being added or data migration tasks being carried out. These database adjustments ensure the system can handle new features, optimize performance, and improve security.
Accepted Solution
Updated: 1 Apr 2025 9:40 EDT


Pegasystems Inc.
IN
If you are looking into changes in database , like changes to table, columns etc, then you can generate the upgrade DDLs first.
In upgrade bundle, in scripts folder, there is a file generateDDL. You can execute it by passing right parameters, which will generate the DDLs which can be applied manually before executing the upgrade.
Changes are specific to per client environment.
Thanks
Suhas