none
SQL Server Support for GDA2020 RRS feed

  • Question

  • We currently use a mix of MS SQL Server database versions to store a range of spatial data for a range of Queensland State Government departments.

    We are investigating migration to the new GDA2020 datum, but have encountered problems with SQL Server not supporting the new SRID.

    The only other post I can find on this forum regarding GDA2020 simply confirms that even SQL Server 2019 does not include support for GDA2020 by default, but fails to provide any advice on what actions Microsoft is taking to remedy this situation for any MS SQL Server versions, existing or planned.

    Is anyone able to provide any details regarding the timeline for the introduction of GDA2020 support in MS SQL Server, either via new versions or patches for existing versions?

    Jon Bastow

    Spatial Systems Administrator 

    Information Technology Partners

    Queensland State Government

    Monday, July 8, 2019 12:12 AM

All replies

  •  Hi, 

    Anyone has some ideas?

    Wednesday, July 10, 2019 9:13 AM
  • I'm also curious to find this out.

    Will GDA2020 support be provided for earlier versions of MS SQL Sever?
    Thursday, July 11, 2019 6:58 AM
  • Unofficial response to our initial Microsoft enquiry:

    I’ve asked our local SQL technical specialists, and they are not aware of any plans to backport to previous releases of SQL server (which is a pretty rare event), however as this would be a support / servicing led activity internally at Microsoft, the most authoritative answer would be via a Premier support advisory case to ask if GDA2020 is planned to be added to any previous version of SQL.

    Our infrastructure team have raised the suggested Premier support advisory case, but we are not holding our breath for a positive response.

    Friday, July 19, 2019 2:11 AM
  • Followup - The product team for SQL confirmed GDA2020 update is planned for SQL 2014+, although engineering couldn't give a firm date. About the same time it turned up for 2014, although the article mentioned applying to 2016+ as well.

    Today the article has been updated with links to 2016-2017 Cumulative Updates:

    https://support.microsoft.com/en-us/help/4506023/fix-geocentric-datum-of-australia-2020-is-added-to-sql-server-2014-201


    Wednesday, July 31, 2019 10:36 PM