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.
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:
@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.
@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?
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.
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
@KiranU8720 Any update on this please ?
