Can we import History from 1 server to another?


We upgraded our PEGA instance from PEGA 7.1.8 to 7.3.1. Since the source was the baselined version of Production hence no history was captured of any rule, since pr4_history_rule and pr_history_data had limitation only in Development Server.

This copy of Production with upgraded server was made as development and now the irony is we have to refer the old dev server also to check the history of all the rules which is not available in new server.

can we export pr4_history_rule and pr_history_data from old DB to new one knowing it has a pzpvstream column for BLOB, will that be problematic. Please suggest as we are not getting the path forward.



Keep up to date on this post and subscribe to comments

September 20, 2019 - 12:36pm

You should be able to export all columns from the pr4_history_rule and pr_history_data, excluding the BLOB column (pzpvStream) and achieve the results desired.  The data necessary is in all the other columns and the BLOB is redundant even in 7.1.8 - which is why we removed it in later versions.