Question
Areteans
IN
Last activity: 27 Sep 2019 2:17 EDT
Pega application - running in different DB versions will it have any SQL generation issues
we have database version Oracle 12c in Dev/ SIT /UAT /OAT in prod alone we have Oracle11g
both the version is compatible as per the platform guide. not sure what are the impacts when we try to promote code which is designed in latest db version to the production which old version
I know pega will dynamic do SQL generation based on rule change or run time scenarios
please advise on the impact which we can expect and would like to prepare for it
Accepted Solution
Pegasystems Inc.
US
I don't think anyone can predict the impact. However, from Pega's perspective, SQL generation should work on either DB versions. I would expect your Pre-Prod should be in line with Prod env, otherwise, there is no way of testing before moving the code to Prod - any reason what that is case? The biggest impact I can possibly think of is the performance. Oracle 12c is a newer version and supposed to be better - so you could have the situation where everything works fine in lower env and not so well in Prod env. I am also aware of special cases Oracle 12c optimizer performs worse.