1

Re: Server Upgrade

Our ITC guy has asked me to enquire..

We are about to have new servers and are moving to a 64 bit system and probably upgrading to SQL Server 2008 in the process.

So the questions is, are there likely to be any problems running Recorder 6 in a 64 bit environment and does it work with SQL 2008? Alsoif anyone wants ot ofer advice on the migration process, that would be good too.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre

2

Re: Server Upgrade

Hi Rob.

In my experience, there is an issue (at least on the 6.14.4 install disk) with installing standalone Recorder onto a 64 bit Windows machine with an existing 64 bit version of SQL Express. This is because the installer does not detect the presence of the instance, due to the way that 64 bit Windows virtualises the registry (so the software requests a registry key to check if SQL Express is present, but gets mapped to a different part of the registry where the 32 bit registry entries are kept, therefore fooling Recorder into thinking SQL Express is not installed).

If you install a 32 bit SQL Express 2008, or use the 2005 one on the disk, then there are no problems I am aware of that result from either SQL 2008 or Windows 64 bit. I haven't tested the network installer on 64 bit Windows but I don't know of any reason why it should not work as normal. Recorder itself seems fine once installed.

John van Breda
Biodiverse IT

3

Re: Server Upgrade

We can keep each other company Rob as we are in the same boat. We just ordered the same bit of kit to replace our dead server.

Data Manger
Somerset Environmental Records Centre