Shubham Member since 2016 6 posts
Posted: July 18, 2019
Last activity: July 18, 2019

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.

How can we sync schema in both the environments.

Pega Platform Low-Code App Development Data Integration Cloud Services
Moderation Team has archived post
Share this page LinkedIn