Question

1
Replies
9
Views
Shubham Member since 2016 6 posts
Cognizant
Posted: 1 year ago
Last activity: 1 year 2 months ago
Closed

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.

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