SIMS Summer 2025 on SQL 2014

[Olliekai]

SIMS Summer 2025 release doesn't support SQL20214.

 

Has anyone Installed this release on SQL 2014? Any issues? Etc

 

 

[3s-gtech]

If it doesn't support it, it may actually use a different tool and command set. If you risk installing it, it could **** itself incredibly hard (though I imagine it'll have failsafes to hard prevent you from doing it).

 

Time to upgrade SQL. No way round it.

[willtech]

Not supported and you won't get support even if you get it to work. Don't risk it ! See the roadmap: SIMS7-Technical-Roadmap-Spr25-1.pdf

Edited July 10, 2025 by willtech

[Olliekai]

Ouch, I thought this was going to be the case. 

[phil0569]

Yep we are in the same boat having to upgrade before we can do the summer update, and it has to be done before the end of September 2025.  They said that data had to be synched with next gen to be able to do the summer update as well, but in previous documentation it said this didn't need to be done before Summer 2026 (census time).  Me thinks they are changing the goal posts.

[Olliekai]

5 hours ago, phil0569 said:

Yep we are in the same boat having to upgrade before we can do the summer update, and it has to be done before the end of September 2025.  They said that data had to be synched with next gen to be able to do the summer update as well, but in previous documentation it said this didn't need to be done before Summer 2026 (census time).  Me thinks they are changing the goal posts.

They probably are.

 

[dmj]

7 hours ago, 3s-gtech said:

Time to upgrade SQL. No way round it.

I can think of a few options:

Arbor, Bromcom, iSAMs

[psydii]

9 minutes ago, dmj said:

I can think of a few options:

Arbor, Bromcom, iSAMs

You forgot SIMS NG/ Connected!

 

I'll see myself out

[Space_Munkey]

Hypothetically...

 

What if you just installed the latest SIMS Summer 2025 update... on SQL 2012... because you were under the impression you were on at least 2014, but that didn't matter anyway because of the 2014+ requirement...

 

HYPOTHETICALLY of course...

 

ohdeargod

[FN-GM]

SQL 2014 has been EOL for a year. Regardless of what SIMS supports, you're not applying security patches and this is a cyber security risk.

[Space_Munkey]

How exciting...

 

It's going to be a busy summer 🥵

[bknaggs]

There is an in place instance upgrade option within the SQL installer. I did this when I upgraded SQL on our SIMS server.

 

If you're on a VM then snapshot first but it should be a lot less scary than you are possibly imagining.

[DarkMaster]

this is what i am doing at the moment on our five sims servers, but also make sure you have upgraded to the latest service pack before you attempt the upgrade and possible uninstall the old obdc and ole drivers

Edited July 22, 2025 by DarkMaster