Hi,

Has anyone tried to move the MS SQL database with Baan IVc4 (a 2-tier installation setup: both DB and appl on the same server) to a 3-tier setup? That is, just move the MS SQL 2000 database out from the original Baan installation onto a second server with pre-installed MS SQL 2000 already there? Then leave just the Baan application on the original server while connecting to the DB on the second server?

Please advise if anyone has tried this scenario?

Thanks in advance.

Yes, it is possible.
Make sure, the existing sql server instance has sort order set to binary.

In the past I had created the database, group and user manualy and used bdbpost to post the tables. Then change the tabledef6.2 file to add the parameter MSQL_SERVERHOST (or something similar) to point to the new server.

It could be possible to also use db detach and db attach procedures from ms sql to unink and link the database files from one server to another server. But never tried it.

best luck