Home > Forum > Database > 2 BPS_Content databases?

2 BPS_Content databases?
0

Is it a common practice to have more than one BPS_Content database? I am wondering whether it can help separating the work of 2 departaments and ensure some independence?

If so, how to manage which application should use which BPS_Content database?

Kind regards
Lukasz

MVP

Hi Lukasz,

each content database has their own applications with own ids. You can import the same application in both databases but you should modify the application group name afterwards. Importing the same application (Guid) twice will require a change in the global parameters. I think it’s called something along validate unique process ids during import.

We have theee different use cases for multiple databases:

1. One database with GxP critical applications which need to be validated and the other one for „normal“ applications.
2. Requirements due to legal reasons. For example one customer needed to separate the data by country. They are using the same process in different countries where they again have multiple business entities.

3. One extremely growing process with a lot of workflow instances. This was just a
decision from the SQL administrators due to recovery concerns.

Best regards,
Daniel

Creating multiple BPS_Content databases for the system is very helpful in terms of scaling and system performance because when creating a new BPS_Content database, the data tables (wfelements, wfelementdetails, wfhistoryelements, securities, etc.) are empty and the data for them registers anew.

In the case of applications, you decide on which BPS_Content base you want to create the application and develop it on that base.

You have to create the base from the installer - give the appropriate permissions and in Designer Studio switch to the new base and create the application on it.

Did you know that with WEBCON you can automate virtually any process? Even baking cookies 🍪
 
Speaking of cookies: we use the ones that are essential for our website to function properly, as well as additional ones that help us customize our content to your preferences. If you don’t mind cookies, click Accept. If you want to learn more, explore settings.
Settings