1

Topic: Migrating database to new server

Is there a document on migrating a Recorder 6 database to a new server? I'm sure this exists but haven't been able to track it down!
Thanks
Andy

2

Re: Migrating database to new server

There is one somewhere Andy, but I haven't found it either. You should be able to find what you need on here. I would google "NBN Forum new server" and see what comes up. Try not to be put off by my recent postings about the horrible time we've had doing it.

It will depend on your OS & which version of SQL you are using and whether you are installing the Recorder software on there as well, but basically:
Install SQL Server on the new server
Install R6 software & upgrade to same version as your old installation (running as administrator if on a recent version of Windows)
Then either detach the database from your old server and attach it to the new one, or make a back up from the old one and restore to the new one.
Uninstall & reinstall workstations (again as admin)

That should do it, but there are a lot of variations possible.

Rob Large
Wildlife Sites Officer
Wiltshire & Swindon Biological Records Centre