Upgrade from MS SQL 2008 and Arc sde 10 to latest version

Question

Currently we are using ArcDesktop 10, ArcGIS server 10 and ArcSDE 10 along MS SQL 2008 64 bit sp2 now we are going to upgrade Arcgis desktop, server  to latest version and we are also planning to Migrate fro MS SQL 2008 to MS SQL 2014 or any latest stable version.

1. Please someone can give me lead and hints about steps

2. Is it recommended to use sql geometry rather than sde geometry

Asrujit SenGupta​ Please provide your valuable inputs

shafitrumboo · Answer

Thanks for you reply

After going through the link Methods to move a geodatabase in SQL Server—Help | ArcGIS for Desktop

Currently we don't have latest version of Arcgis or sql but we are going to have it soon. so I'm just wondering.

1. Will this is applicable also for upgrade from MS SQL 2008 and Arc sde 10 to latest version of Sql server and ArcSde ( In case we decide to use it)

2. Do we need to do some extra steps to use this data in Arcmap and publish services from Arcgis server.

Yes we want to choose between SDE Binary and Geometry. It will be appreciated if you can which one is preferred and some advantages and disadvantages like

1. Will Arcobjects will work on SDE Binary, Geometry.

AsrujitSengupta · Answer

You can refer to some old threads for reference steps related to the migration. Like this one below:

Migrate from OLD SDE Server to New One

An SDE Geodatabase in SQL Server can have three storage types -- SDE Binary, Geometry and Geography. Are you looking to choose between SDE Binary and Geometry?