Hello,

our existing setup - Baan IV C4 upto sp-17 and sql 2000.
We are going to open a new branch office in different location.

we are thinking of creating an new company in existing baan installation and point this baan company to a separate database which will be on a different server.

so that this new baan company is used for new branch transactions.new branch will use our existing Baan setup.only diffference would be new baan company and a separate database on different server .

Would you recommend this scenario and how would it be in terms of performance ?

Kindly suggest.

Hi RKing,

sorry, but I can't follow your thoughts here.
When you say
<quote>new branch will use our existing Baan setup.</quote>
do you mean that they will use your old application server and data for company 000
or do you mean that they will have a server for themselves containing a copy of your Baan system?
Perhaps we can give you more clues if you answer the following questions:
a) Is there any need that one company (or branch, as you put it) has direct access to the data of the other one?
b) Do you change/modify your system on a regular basis? (Install sp, change forms/reports/sessions)?
c) How many people will work with the new system.

The number of DB servers is not important, the first question to be answered is the number of application servers needed.

hth

Norbert

Hi Nobert,

Good Morning,

yes new branch will use old application server and data of company 000.
they will connect to old server using Bw client.
a)they will not have access to other company data.

b)yes we do modify our system.ie customizations,installation of SP.

c)on the new system may be less than 10 users.

Hope my answers are clear.

Thank you.

Regards
Rking.

Depending on the connection between these two branches, you could even look at replicating the database, perhaps?

Or even better, Single Finance / Multi Logistic?

sk

Please tell us why you need different database for a single company data that will be used by only 10 users. Additional DB server is going to increase your administrative activities...

If you have enough space and memory available on current DB server, keep the new company data on same DB server. You can create separate tablespace for the new company for better management.

Regards,
Kaustubh