Hi,

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.

Thanks,

Manikumar 

Let me clarify my question.

I am only interested in tables that are maintained by Pega. I'd like to update my environment in two steps:

1. Automatically and exclusively only apply DB changes to an environment. 
2. Automatically and exclusively only apply rule updates (inserts) to an environment.

For step 1. I need to get hold of the actual SQL statements, because the DB is outside of my control. Is there an automated way (not a manual way) to extract the SQL statements from a RAP?

For steps 2. I need a guideline / recipe of how to construct the RAP. Is that available?