I am looking for best practice to isolate schema changes during deployment.
Is it conceptionally possible to
- create a RAP with schema changes only?
- automatically (not manually) generate the SQL statements for a particular environment (either at the time of RAP creation or RAP import)?
I have not experimented yet, but I assume that the actual SQL depends on the target system.
This actually brings me to other questions:
Is the generated SQL independent of the actual DB flavour? (ANSI SQL?)
Does the generated SQL always contain all changes wrt. to a 'new' DB?
Can the generated SQL cope with variations in the target DB? (E.g. a table already exists or a property is already exposed)?
As part of moving schema changes to higher environments,
1) If its a change in the table then save the Data-Admin-DB-Table instance of that particular class and include in the RAP, the time of deployment to higher version it will give an option to generate DDL query which we can download execute @DB level or we can go ahead with deployment which the table will be saved.
2) If any addtional schema changes like manullay we need to execute some query to add/truncate etc..we need to write sql query and need to execute in higher environments.
Hope this help.
Posted: 5 years ago
Posted: 30 Nov 2016 10:25 EST
Andreas Sittler (SITTA)
Principal Solutions Architect
I am working on automated Deployment process and for that before deployment, I want to get schema changes from the archieve by comparing the target DB.
I know from pega import wizard we have option to download the schema changes, but I want to do it from command line. Here I saw your respose that we can run "prpcUtils.bat/sh generateDDL" command.
I updated the prpcUtils.properties file and executed the commane. But at run time I am getting exception saying "java.lang.NoClassDefFoundError: com/pega/pegarules/internal/bootstrap/BaseLogger".
Could you please help me on this.
I have attached the Command output for your reference.
Thanks & regards,
Posted: 5 years ago
Posted: 20 Jan 2017 9:09 EST
Saran Kolla (SaranKolla)
Senior Technical Solutions Engineer