[GIS] Using PostGIS functionalities in Microsoft SQL Server?

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 4 years ago.

Improve this question

I'm using Postgresql 8.4, Postgis 1.5 for My GIS works.
Planning to change my Database to Microsoft SQL Server 2012.

Can we use all the Postgis functionalities in Microsoft SQL Server 2012?

Answer 1

MS SQL Server includes spatial functions, but the functions are usually named differently, for example PostGIS's intersect function is named ST_Intersect and in SQL Server it is called STIntersection.

Your best bet to migrate would be to use ogr2ogr to move your data from Postgres to MS-SQL, then you'll have to re-write any queries you're using in Postgres.