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
The procedure for migrating a Recorder 6 database (NBNData_Data.MDF, and the associated log file, nbndata_data_log.LDF) to a new server is very similar to swapping from MSDE to SQL Server 2000 – the instructions for which are in the Network Installation Guide (page 10) which is available from http://jncc.defra.gov.uk/page-4595 , except that you should use the SQL Server 2005/8 tools, called Management Studio Express, instead of Enterprise Manager, the SQL Server 2000 tools. Note that if you copy and paste the query in point 11, you often need to re-type the quotes before it will run.
Please note the points about SQL Server 2012 and Windows 8 in http://forums.nbn.org.uk/viewtopic.php?pid=18532#p18532 and that user added files like rucksacks and recording cards will also need to be transferred.
Forum → How Do I... & Other Questions → Migrating database to new server
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.