Microsoft SQL Server and Azure SQL Database Spatial Quick Facts

About Quick Facts Tables

Format Type Identifier

MSSQL_SPATIAL

MSSQL_AZURE_SPATIAL

Reader/Writer

Both

Licensing Level

Reading: Professional

Writing: Database Edition

Dependencies

Microsoft SQL Server 2012 (or 2008) Native Client.

Microsoft System CLR Types for SQL Server 2012 (installed with FME except in silent installs).

Microsoft .NET Framework v4.5.2.

Dataset Type

Database

Feature Type

Table name

Typical File Extensions

Not applicable

Automated Translation Support

Yes

User-Defined Attributes

Yes

Coordinate System Support

Yes

Generic Color Support

No

Spatial Index

Yes

Schema Required

Yes

Transaction Support

Yes

Encoding Support

Yes

Geometry Type

mssql_spatial_type

Microsoft SQL Server and Azure SQL Database Spatial Geometry Support

Geometry Supported?
aggregate yes
circles no
circular arc yes
donut polygon yes
elliptical arc no
ellipses no
line

yes

none yes
point yes
polygon

yes

raster no
solid no
surface no
text no
z values Reader: yes

Writer: yes (except for SQL Server 2008 non-bulk mode)