Sims not supporting SQL 2016 from Spring 2020 without service packs - Questions

[TwistedHelixis]

I remember reading that from the spring 2020 update Capita would not be supporting SQL 2016 unless it has service packs.

 

1. Where is the product road map in the Capita portal, I am going round and round but can't find it.

 

2. If a school has no service packs, can I install SP2, or do I need to install SP1 and then SP2?

 

3. The first school I have just checked has an SQL version of 13.0.4259.0, does this equate to SP1.

 

Sorry for all the questions.

[r0cketbev]

Hi TwistedHelixis,

 

I don't the answers to 2 and 3 but I know the answer to 1, see below, link to the roadmap from capita.

http://www.capitaess.co.uk/home/TechnicalRoadmap-May-2019.pdf

 

RB

[Norphy]

SQL service packs include all previous updates so you will be able to install SQL 2016 SP2 directly without having to install earlier service packs.

 

A list of SQL build numbers can be found here: https://buildnumbers.wordpress.com/sqlserver/

Edited December 17, 2019 by Norphy

[TwistedHelixis]

Looks like SP1 is already not supported. I will be upgrading tonight then.

[Norphy]

You may as well go the whole hog and make sure you have the latest cumulative update after you get SP2 on there as well:

 

https://support.microsoft.com/en-us/help/4527378/cumulative-update-11-for-sql-server-2016-sp2

[Koldov]

Hi,

 

Sorry to hijack the thread but my post received zero replies (maybe it's a silly question)....

 

When updating SQL (mine is 2014 but I guess it applies all round), do you need to do anything to the databases like detach them (primarily asking about SIMS, but again the info could be transferable)?

 

Mine hasn't been updated since install I think from looking at the version (File Version - 2014.120.2269.0) so is it ok going straight in and hit it with SP3 then CU4?

[Norphy]

You can install SQL updates without having to detach databases etc. That said, it's sensible of course to make sure that your backups are in order before you update and to make sure that no-one is attempting to use SIMS while you're doing your work. Updating to SP3 then the latest CU will be fine.