Syncing issue in Default Database schema in Dev and stage
Hi,
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.
How can we sync schema in both the environments.
Cognizant Technology Limited
IN
Hi,
You can try opening the database instance in STG and run the DDL in the respective schema.
What do you meant by default option in Dev & STG? Do you mean DBSCHEMA A is an external schema?