Good morning, does anyone know of a way that I can convert .GML files to a format that is recognized by SQL spatial? Thanks

MBrady,

SQL Spatial can import from GML, but it actually only supports a subset of GML ( SQL Server's profile of the GML Schema ), so you may encounter errors. Have you tried it? If not, do something like this:

DECLARE @g AS geography = geography::GeomFromGml(@x, 4326);

Let us know how it goes.

There are commercial tools like Safe FME that might help, though last time I checked it was pricey?

Eric