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