AnsweredAssumed Answered

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

Question asked by tpcolson Champion on Jul 28, 2014
Latest reply on Dec 16, 2016 by Scott.Fierro

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.

Outcomes