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.