Is it possible to reproject spatial data using SQL Server?

Question

SQL Server takes an SRID when creating spatial data, but is it possible to retrieve an object as a different spheroid?

For example, let's say I have a bunch of spatial polygons using SRID 4258, but I'd like to use alongside some pre-existing data that has an SRID of 4326 -- are there built in conversions, or do I have to handle this conversion myself?

Answer 1

No.

Transform - ability to transform from one spatial ref to another: No - need 3rd-party tools, Geometry can use any SRID between 0 and 999999. Spatial Tools free CLR add-on does provide limited transform support.

Source: http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare

Answer 2

Not by default, but check the SQL Server Spatial Tools developed by MSDN on CodePlex. Specifically, the affine transformation functions.