Posted: 19 Jun 2015 3:21 EDT Last activity: 6 Apr 2018 19:26 EDT
Guidance on mapping transactional data in different DB schema
Suppose a client has multiple applications running in the same box. After upgradation, they want rules of all these application be mapped in same Rules schema, but the data schema will be different for each application. Need guidance on how to map application specific transactional data in separate DB schema per application. Thanks in advance.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
The question is, suppose I have 2 application running in same Application server. I want rules of both application will be in single rule schema, but the data of the 2 application will be in 2 different data schema under same database. How to implement that? How I will segregate application specific Data to two different data schema?
Note: I work with "ARNABCHAKRA " who posted the question first.
I assume you are talking about Split Schema configuration. You can't have two different data schemas with sinlge rules schema. Becaus the data schema will contain the all the work-, data- related tables which includes system related tables like pr_operators, pr_data_admin etc.
However if you want to maintain seperate schema for only application specific work tables that is still possible. You need to create D-A-DT instnace for that specific work table and map it to dedicated applicaiton specific work schema.