Syncing issue in Default Database schema in Dev and stage
In Dev environment DBSchema A is a default option and all tables are created in DBSchema A while creating tables from Pega.
In STG environment PegaData is a default option and all the tables are created in PegaData while creating tables from Pega.
e.g.: I tried importing a DDL from Dev to STG the below query comes:
--execute on the database specified by Data-Admin-DB-Name DBSchema A:
CREATE TABLE pegadata.pr_Org_Div_data_******
This means our Dev. environment is not in sync with STG environment in terms of schema selection. Moreover we are unable to change the schema to PegaData to DBSchema A or vice versa.