topic Re: SDE Upgrade SQL 2008 to 2012: Does it blow up? in ArcGIS Enterprise Questions

SDE Upgrade SQL 2008 to 2012: Does it blow up?

ThomasColson — Mon, 28 Jul 2014 19:31:20 GMT

Has anyone gone down the road of a SQL 2008 to 2012 upgrade? I almost exclusively use the Geometry storage format, and SQL 2012 upgrade advisor is complaining about: Warning about client side usage of GEOMETRY, GEOGRAPHY and HIERARCHYID The assembly Microsoft.SqlServer.Types.dll, which contains the spatial data types, has been upgraded from version 10.0 to version 11.0. Custom applications that reference this assembly may fail when certain conditions are true.

I'll naively assume this doesn't affect ArcGIS operations.....?

What about doing in in-place-upgrade versus a new install? There are pros and cons to both, the in-place upgrade could fail, and the new install will take forever, In either case, I have good backups of the server the databases, I just want to go with the least-work option.

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

BillFox — Fri, 30 Sep 2016 00:41:22 GMT

Does anyone have a status update for this question?

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

DrewDowling — Fri, 30 Sep 2016 02:54:15 GMT

Running into this exact same issue. From what I can gather from the searching I've done it should be OK if the client has the correct version of the SQL Server native client. I'm doing it on a test server tonight and will report back if I find any issues.

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

ScottFierro2 — Fri, 30 Sep 2016 11:13:01 GMT

It should work fine, we are testing the SQL 2012 to 2016 upgrade in the next week or so. Here's a helpful post regarding some things others have found. I made a post there specific to configurations of the drives that you will see in comments made a big performance difference for several people.

https://community.esri.com/message/398338

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

ThomasColson — Mon, 03 Oct 2016 11:53:45 GMT

Sorry yes. 2008 -> 2012 -> 2014 have all went smoothly.

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

KimSoulliere — Wed, 07 Dec 2016 16:29:30 GMT

Did you do an in-place upgrade? Other than backups of the databases, any steps in ArcGIS before or after the upgrade, in SDE or ArcServer?

We are upgrading SQL 2008 to 2012.

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

DrewDowling — Fri, 16 Dec 2016 00:34:04 GMT

We did an in place upgrade from 2008 RC2 to 2014. The only issue I ran into was poor performance on a couple of feature classes after the upgrade. Deleting and recreating the spatial index on these feature classes fixed the problems.

Re: SDE Upgrade SQL 2008 to 2012: Does it blow up?

ScottFierro2 — Fri, 16 Dec 2016 12:09:56 GMT

We generally always stand up a new VM for the upgraded database environment. Once we are confident its configured as intended then we migrate a backup of the SDE. Post migration we run some checks and rebuild the stats & indexes on everything (265GB database full compressed) and it usually takes under an hour to complete all that. Thus far we have done this for 2008 R2 -> 2012 for 3 different server/DB environments (DEV, TEST & PROD all migrated same way) and are doing it again for 2012 -> 2016 (doing all 3 environments again).