How can I convert Geometry data into a Geography data in MS SQL Server 2008?

Question

How can I convert some Geometry data into Geography data in MS SQL Server 2008?

Farnham

Answer 1

Yes you can but the geometry datatype is more forgiving than the geography in my experience. So there is some data you might have in geometry that you can't convert.

This article from Spatial Ed was very helpful explaining how to fix data problems and also has some sample queries to convert from Geom to Geog.

Kibbutznik

No offense, but "link only" answers are frowned upon and I think it would be better to answer the question. – Fie

Especially seeing that the link now produces "Oops! That page can’t be found. This page has been disabled." – Sharilyn

This is no longer a valid answer really. See this other answer instead – Bugg

For those that care, here is the wayback machine link for that Spatial Ed article – Astor