topic Re: Migrating to Azure SQL from On-Prem SQL Enterprise in Geodatabase Questions

Migrating to Azure SQL from On-Prem SQL Enterprise

JoeFlannery — Fri, 13 Nov 2020 18:24:09 GMT

We are in the process of migrating our GIS infrastructure up to the Microsoft Azure cloud. We currently use on-premises Microsoft SQL Server Enterprise for our geodatabases. The plan is to move our SQL geodatabases into Azure SQL. Esri’s online help titled “Functionality differences for geodatabases in Azure SQL Database” indicates that “Use either Microsoft Geometry or Geography data types for the spatial fields in your feature classes; sdebinary storage is not supported.”

An inspection of feature classes in our current SQL geodatabases reveals that we are using “Geometry spatial type” (see attached image).

My question: Is the “Geometry spatial type” that I see associated with feature classes in our current on-premises SQL Server Enterprise the same as the “Microsoft Geometry” data type mentioned in the Esri online article that is used in Azure SQL?

Thank you for your time and attention.

Sincerely,

Joe Flannery

Re: Migrating to Azure SQL from On-Prem SQL Enterprise

George_Thompson — Mon, 16 Nov 2020 15:09:43 GMT

Hi Joe - Yep, those are the same. The help is saying that SDE binary is not supported. The default for new data has been SQL server geometry since 10.1 (I think...)

You should be good.

Re: Migrating to Azure SQL from On-Prem SQL Enterprise

JoeFlannery — Mon, 16 Nov 2020 13:51:25 GMT

George:

Thank you for taking the time to answer my question. Your response pleases me as it should make our move to the Azure cloud less complicated.

Sincerely

Joe