Hi

I have to upgrade our Baan IVc4 system:

1) MS SQL 7 database to MS SQL 2000
2) Windows 2000 Server to Windows 2003 server

Has anybody with any experience of either upgrade got any advice, tips or warnings which may be helpful? I am guessing that they should be straightforward, but somehow these things are rarely as simple as they should be ......

Many thanks

I recently upgraded from a NT4/SQL7 box to W2K Advanced/SQL 2000 Enterprise. It was relatively painless. Here's the basic process I used:

Stop SQL

Do a backup

Start SQL

Execute sp_helpfile for the baan database (baandb in my case). This will tell you the physical locations of the file

Detach the baan database with sp_detach_db

Do a backup

Install new OS (this was on a new machine for me, so was already completed).

Install SQL

Install Baan

Install current portingset

Restore Baan ($BSE) directory from old server over newly installed $BSE

Restore detached db files from old server to the location you want them at on the new server

Attach the Baan database with sp_attach_db

In theory, you should have a good system at this point. Of course, in these types of processes, small things always pop up that you have to deal with. If at ALL possible, I strongly suggest that you do several test runs of this process prior to going live.

Last step is revalidation.

Hope this helps!

Thanks,

Vince

Thanks.

This is slightly different. It is an in-place upgrade on existing hardware, but thank you anyway.