IKGPAT
23rd August 2006, 14:47
is it possible to have two unique databases on same box. I have two db's on different servers and would like to put them on same box. One box uses english and the other box spanish. I wanted to know if possible to move spanish db on same box as english version keeping its own baan directory for DD and other files.
thanks

mostrightfuture
4th September 2006, 14:04
Hi IKGPAT,

As DB servers support many database on the same DB server, you can have as many database on the same box as server supports, DB name should be different. You can say baandbEN for english and baandbES for spanish.

Personally, I dont have experiance having multiple Baan DB on same box but we have many databases of other applications on the same SQL server.

MRF

pokitlok
4th September 2006, 20:12
You may create several databases on single box as below:
1. Create multiple instances on the MS SQL server
2. Create a database (same name as database user group) in each instance; for access control, the databases are in different names, i.e. database user groups are different

But I am not sure if you can keep multiple sets of DD on single box. Maybe you can separate the different set of BaaN files into different folders. You create different bw files which point to different BaaN folders.

IKGPAT
5th September 2006, 04:50
thanks - since both db's already exist - do you know of any problems renaming one

pokitlok
5th September 2006, 06:39
As per I know there is no problem to change the db name, but you recommend to make the SQL db name, SQL db role and BaaN db user group in same "word".