Discussion
Fresh Pega 7.1.9 Install
Hi,
I have installed fresh pega 7.1.9 on dev environment. when i go to higher environment installation, instead of re-doing the work, can i just simply copy the rules and Data schema?
I believe in higher environments, if we clear few cache tables and few data schema related tables it will work. Can you please confirm? and i can use this as a master copy.
When i installed below are the rule tables and Data schema counts.
Rule_Table Name | Counts |
PR_INDEX_REFERENCE | 906427 |
PR_SYS_APPCACHE_DEP | 184345 |
PR4_RULE_VW | 148957 |
PR_ENGINECLASSES | 117927 |
PR_ASSEMBLEDCLASSES | 94563 |
PR_INDEX_CSS | 88043 |
PR4_RULE | 77616 |
PR4_RULE_SYSGEN | 56842 |
PR_SYS_APPCACHE_SHORTCUT | 48683 |
PR_REFERENCE_PAGE | 44563 |
PR4_RULE_PROPERTY | 28435 |
PR_SYS_RULE_IMPL | 25444 |
PR_DATA_MAP_ENTRIES | 22374 |
PR_SYS_APPCACHE_ENTRY | 21400 |
PR_SYS_CLASS_ANCESTORS | 17120 |
PR4_RULE_LIBRARY | 9677 |
PR_SYS_DECCHG | 9511 |
PR4_RULE_FILE_BINARY | 9314 |
PR4_FIELDVALUE | 8495 |
PR4_RULE_FILE | 6583 |
PR_CHANGELOG | 5503 |
PR4_BASE | 4282 |
PR4_RULE_MESSAGE | 2068 |
PR4_RULE_RULESET | 977 |
PR4_RULE_FLOW | 927 |
PR4_RULE_DECLAREPAGES | 682 |
PR_SYS_RULESET_INDEX | 630 |
PR_LINK_USECASE | 469 |
PR_INDEX_CUSTOMFIELDS | 449 |
PR_INDEX_RULE_AGENTS | 129 |
PR4_RULE_SHORTCUT | 125 |
PR4_RULE_USECASE | 56 |
PR_SYS_APP_RULESET_INDEX | 42 |
PR_SYS_APP_HIERARCHY_FLAT | 10 |
PR_DATA_RULE_APPMETADATA | 3 |
PR4_RULE_DELEGATIONCONFIG | 3 |
PR_DATA_ADMIN_PRODUCT | 1 |
Data Table Name | Counts |
PR_DATA_ADMIN | 230 |
PR_DATA_SAMPLE_UIDETAILS | 104 |
PR_DATA_SAMPLESRPURCHASE | 90 |
PR_SYS_QUEUE_FTSINDEXER | 37 |
PR_SYS_WORKINDEXER_QUEUE | 37 |
PR_DATA_SAMPLESRCUSTOMER | 28 |
PR_DATA_SAMPLE_SHOPPINGCART | 25 |
PR_SYS_UPDATESCACHE | 20 |
PR_DATA | 16 |
PR_LICENSE_PARAMETERS | 15 |
PR_DATA_DMS_CUSTOMER | 10 |
PR_OPERATORS | 9 |
PR_DATA_SAMPLESRPRODUCT | 6 |
PR_SYS_STATUSNODES | 5 |
PI_DATA_CONNECT | 1 |
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
A copy of the schema for a fresh install is possible, but remember few instances in Pega are system specific.
Like the system name information is maintained in the System rule which needs to get updated and similarly the DSS holding that information.
Also, you might want to change the Production Level setting between these environments.
If you do a fresh install it would hardly take 1 hour of time, so whether you do a copy of DB or do a fresh install it would be the same amount of time.