FAQ - Upgrades
Q. Moving to New SQL Server Version
A. Recorder 6 will run on SQL Server 2000 (MSDE)/2005/2008/2012/2014/2016. Support for SQL Server 2000 will probably be withdrawn in 2018. You can move up two version without any problems ie. ( 2000 to 2008, 2005 to 2012, 2008 to 2014, 2012 to 2016 ). Moving from SQL Server 2000 to SQL Server 2012, 2014 or 2016 is not possible without going through an appropriate later version of SQL Server. To avoid the need to install and intermediate version of SQL Server ask for help on the Forum. Anyone with SQL Server 2008 /2012 who has Management Tools will be able to help. they will need a copy of your database file (or a backup).
Q. Network Upgrades
A. The upgrade does two things. Firstly it upgrades the database by making changes to the tables, user defined functions etc. Secondly, it replaces the Recorder 6 application on the server with the latest version. The upgrade does not make any changes on the workstations. The upgrade takes only a few minutes to run. It needs to be run from one of the workstations as it uses the workstation registry to obtain the SQL instance and location if the application. The main thing to note is that the person running the upgrade must have sufficient permissions on the SQL instance (admin permissions) to make the changes and permissions on the server to replace the application. Following some updates users may be required to use Recorder 6 to rebuild the 4 index tables.
Q. Recorder 2002 to R6 Transfer
The transfer software on the V6.23 install appears to be working, but note that you must have the MS Access database connected. After the transfer rebuild the four indexes. There will probably be a number of rejection of entries in Dictionary tables, but if only these are affected then this is of no consequence.