I would like baan IV to access two different databases on the same server say baandb and edidb (Database is SQL2000 and Server is Windows 2000) , How can i do so ?

- run the install scripts for the databases
- Maintain Database Definitions (ttaad4110m000)
- Assign Tables to Databases (ttaad4111m000)
- Convert to Runtime (from ttaad4111m000)

Hello,

I also would like to point some of my tables to diff Server . Few doubts which i have are :

1 ) Is their any baan doc which tells how to do this ?? if yes, then what is the doc. no.
2) in session ttaad4110m000 what i will specify in system name and in paramters. We are on SQL Server 7 with NT 4. Basically what would be the exact syntax that i will specify in parameter ?
3) in this case do i need to contact BaaN for licencing of another server. This second server will just act as db server where i would just install db ie. sql server.

Regards

Learner

Baan does not have 2 phase commit, so you should not (read cannot) split tables within a company (or a set of shared companies) between databases / machines.

Example (i'm not a logistics guy so...)
DB1 - purchase orders
DB2 - general ledger

DB1 - Insert purchase order A (succeeds)
Ok, the session need to update the general ledger
DB2 - Update general ledger (fails)

Now you have a PO in DB1 with no corresponding entry in the GL.. Bad bad bad!

Dave

Hello,

So u mean to say that i cannot point my baan to read some tables from X Database server and some tables from Y Server for the same company ..... Right ???

But let's say my both the companies are physical or they r not sharing anything , then i can tell my baan to read Company A from diff. database server and company B from different database server. Am i right ???


Waiting for your reply.

Regards

Learner

Learner,

You can do this, but it is not recommended for business critical systems.

In case of companies not having a relation, you can use it.

Hope this helps,
Dick