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
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → How Do I... & Other Questions → 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
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.
Forum → How Do I... & Other Questions → Migrating database to new server
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.