we are planning to update our enterprise SQL Server system, currently our SQL Server is 2008, since SQL Server 2014 is going to be released soon, we are suggested that it would be better to update SQL Server to 2014 instead of 2012. We wonder when ESRI ArcSDE will support MS SQL Server 1014.
we are planning to update our enterprise SQL Server system, currently our SQL Server is 2008, since SQL Server 2014 is going to be released soon, we are suggested that it would be better to update SQL Server to 2014 instead of 2012.
We wonder when ESRI ArcSDE will support MS SQL Server 1014.
Thanks !!
I am not an ESRI employee, so can't tell you that.
However, I think you should consider the following:
- ESRI will undoubtedly need to do some extensive testing and possibly application development before certifying / supporting the new version officially. This may also mean having to wait for the next .x release of ArcGIS / ArcSDE, which again may take considerable time. Can you actually wait that long before abolishing SQL Server 2008, do you have a fixed "latest date" planned for an upgrade? If so, you'll have to go with 2012...
- Are you actually in need of any of the new functionalities of SQL Server 2014, and do you have the hardware to take advantage of it? Looking at the Microsoft pages, the "in-memory" capabilities are boasted for OLTP and data warehousing, but do you need this and can your hardware platform actually deal with this? What edition of SQL Server are you actually going to run? If your edition doesn't even support these kind of things, there is no use in the immediate upgrade to 2014...
- You may actually prefer to stay one version below the "latest", as the major bugs will have been ironed out through service packs or hotfixes.
- A last remark: even if 2014 is supported as database platform some time in the future, it may still mean ArcGIS may not be able to take advantage of some of the new features. This all depends on what these features are and how easy or desirable it is for ESRI to start making use of them in the software, and the amount of development required and customer demands... Since I don't have a crystal ball, and neither do the folks at ESRI, it will take time for this to settle and start influencing developments of the ArcGIS platform.
