Posted: 14 Dec 2016 0:49 EST Last activity: 2 Jan 2017 4:52 EST
PRPC 7.1.6 How to isolate schema changes from an existing archive?
I am working on automated deployment process and want to perform pre-deploymet schema check. I want to get separate sql file from an existing archive/product zip file by comparing the target environment DB from source environmet.
If schema changes are needed then only, generate the sql file.
Please let me know if there is any way to do that.
There are later versions of Pega that the commandline tools (prpcUtils and prpcServiceUtils) will have a generateddl request that will do a comparison from the RAP and the target to see what changes would be needed and emit a sql script. This is similar to what happens in upgrades/updates. This is what I think you are looking for.
I am working on Pega 716. Somehow I managed to get 7.2 utilities and there in prpcUtils.properties, provided 716 DB credentials & all other input needed for generateDDL command. When I tried running the command I got this message at the end. BUILD FAILED