We are trying to use Pega's automatic Schema changes push from one env to another using the Import Tool. The product file has the expected schema changes.
However, it is observed that some of the DB changes are not being applied to higher environment. Few of these are listed below. Is this a Pega limitation, how can we fix this?
1. Drop column script is not working when deployed to higher env.
2. 'Byte' is getting changed to 'Char' in higher env.
3. Change of column data types isn't being applied to DBs in higher env.
Also, if someone could list what all scenarios will not work with Pega AutoDBSchemaChanges.
We have verified creation of table, alter table with column addition, creation of index, constraints are working.
***Edited by Moderator Marissa to update platform capability tags****