1 Topic by Wolfgang

  • Wolfgang
  • Member
  • Offline
  • Registered: 05-09-2012
  • Posts: 42

Topic: Does Recorder 6 run on SQL Server 2022

Hi,
our IT want to update to SQL Sever 2022. Will Recorder 6 then still work?
They have the following questions:
•    Does the product support SQL 2022?
•    What is the high level description of the configuration change required to remap database connection?
o    In-App - In App setting by Administrator that affects the entire application
o    App-Reg-Key - Registry Key on Application Server
o    ODBC -  ODBC on web or application server
o    Config-File - Install or bootstrap Configuration file
•    Description of Configuration Details required to change Database location - Repoint to new instance / cluster as required
(This should include application configuration,  stop/start/re-install procedures as required to facilitate the change)
•    Are there any other details that are pertinent to the update of the application?

Is there somebody who can answer these questions?

Thanks,
Wolfgang

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,679

Re: Does Recorder 6 run on SQL Server 2022

Yes it does run on SQL Server 2022. I have it running here. I am not aware of any problems but it is a complex system and I can't guarantee that there are no hidden issues. It runs in compatibility mode so all you need to do is to detach the database from its current instance of SQL Server and attach it to the new instance. However, bear in mind that you can only move up two version at one time so if you are on something earlier than SQl Server 2017 you will need to move it first to 2017 or 2019. This just involves attaching and detaching it and does not require the installation of Recorder 6.

There were problems with SQL Server 2019 but these do not seem to be there in 2022.

Mike Weideli

MikeWeideli's Website

3 Reply by BDeed

  • BDeed
  • Veteran
  • Offline
  • From: Bolton
  • Registered: 01-03-2011
  • Posts: 457

Re: Does Recorder 6 run on SQL Server 2022

Just to add our council IT department moved Recorder 6 to 2022 last week and there haven't been any major issues (i had to reset a map but that may have been unrelated). I understand they just detached and re-attached as described by Mike.

I had to request a SQL Manager connection be repointed to the new cluster where NBNData is now running but that's un-related to the R6 software. Perhaps something to in mind if you do use anything to connect to the database directly.

Natural History & Biodiversity Data Enthusiast