Select to view content in your preferred language

SQL Server in place update 2016 ->2022

320
10
Monday
GIS412
by
Occasional Contributor

Hello,

Our org has updated to arcgis pro 3.3 and enterprise 11.3. We are also on sql server 2016 sp2. I recently discovered that sql server 2016 is not supported..

Has anyone done in-place upgrade? Since upgrading to sql server 2016 sp2-> sql server 2022 requires us to patch to sp3. I guess we could snapshot the machine in it's current state then patch to 2016 sp3. Once patched to sql server 2016 sp3, test the services and stability. If all are good, then snapshot again and upgrade to 2022. This seems like the best option as we wouldn't have to re-register data and point all our projects and layers to a different data source.

Has anyone been in this situation? Did it work out fine?

0 Kudos
10 Replies
BillFox
MVP Frequent Contributor

hi @GIS412 what's the OS level on that sql server machine?

0 Kudos
GIS412
by
Occasional Contributor

Windows Server 2016, but planning on doing an upgrade to 2025 depending on what strategy we use for updating our sql server

0 Kudos
BillFox
MVP Frequent Contributor

is ArcMap still in the game anywhere?

0 Kudos
GIS412
by
Occasional Contributor

I think I used it one time to do a enterprise geodatabase update. But we all use arcgis pro now.

0 Kudos
GIS412
by
Occasional Contributor

The links are for upgrading windows server. I'm talking about doing an in-place upgrade for our sql server from 2016 to 2022.

0 Kudos
BillFox
MVP Frequent Contributor

sketch up a workflow matrix between the os, sql, odbc driver and esri pieces to do it in phases

Scott_Tansley
MVP Regular Contributor

It's quite normal that you perform an in-situ upgrade, just follow Bill's advice.  The gotcha that I've sometimes seen is that the 2016 DB software becomes 2022, but the compatibility level of the DB file stays at 2016 and needs to be upgraded as well.

I like your approach of taking lots of snapshots as you progress.  I'm very risk averse and take exactly that approach for upgrades and patches.

One thing that I've sometimes seen is that there can be good value in creating a new database, and new geodatabase and then migrating datasets.  It's a big exercise, and hard to do if you're using traditional versioning, but it gives you a nice clean container and a fresh start.  The ability to do this depends on many things, but could be worth exploring if things aren't too complex in your workflows.

Scott Tansley
https://www.linkedin.com/in/scotttansley/
0 Kudos