Question
Pegasystems Inc.
US
Last activity: 28 Apr 2017 15:04 EDT
Is there a way to use migrate.sh for the data schema?
We did an upgrade from Pega 5.5 to 7.2, which involved splitting the schema. We'd like to migrate the tables associated with the data schema from our old single schema name "pega" to a more standard name "data", for consistency with higher level environments that will be installed from scratch.
Is there any way to use migrate.sh on the data schema for a 7.x DB rather than having a DBA do it?
Thanks
***Moderator Edit: Vidyaranjan | Updated Categories***
Accepted Solution
Pegasystems Inc.
US
Virtusa IT Consulting
AE
Is the data schema (as you mentioned) is of your previous 5.5 or latest 7.2?
Accepted Solution
Pegasystems Inc.
US
The migrate.sh script only migrates rules tables to the new schema. If you want to change the name of what will be your data schema in 7.x I would have DBA migrate the schema to the new name before you begin the upgrade to a split schema.
Pegasystems Inc.
US
Thanks...we ultimately just went with a standard export/import. The schema references in the stored procedures, views, and the custom type needed an update but that was simple.
The migrate.sh script only migrates rules tables to the new schema. If you want to change the name of what will be your data schema in 7.x I would have DBA migrate the schema to the new name before you begin the upgrade to a split schema.