locked
newbie question RRS feed

  • Question

  • I am a newbie in SQL Server Spatial. I install SQL Server 2005 and have some shapefile which can be stored in PostGIS.

    How to import the shapefile to SQL Server 2005? How to show the GIS pictures?

    Sincerely

    Thursday, June 10, 2010 7:44 AM

Answers

  • You can use spatial data in SQL Server 2005, using the MSSQLSpatial spatial extensions http://mssqlspatial.codeplex.com/, but unless you've got very good reasons why you can't upgrade, you should upgrade to SQL Server 2008 R2 which has native spatial functionality.

    Remember that you can download the express version of SQL Server 2008 R2 for free, from http://www.microsoft.com/express/database/ and includes all the spatial features.


    Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
    • Marked as answer by YEHOU Friday, June 11, 2010 2:12 AM
    Thursday, June 10, 2010 9:23 AM
    Answerer

All replies

  • Hello,

    SQL Server 2005 do not support spatial data, your need SQL Server 2008 or 2008R2.

    There are free & good tools to import shapefiles into SQL Server 2008, e.g. Shape2SQL.


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Thursday, June 10, 2010 8:12 AM
  • You can use spatial data in SQL Server 2005, using the MSSQLSpatial spatial extensions http://mssqlspatial.codeplex.com/, but unless you've got very good reasons why you can't upgrade, you should upgrade to SQL Server 2008 R2 which has native spatial functionality.

    Remember that you can download the express version of SQL Server 2008 R2 for free, from http://www.microsoft.com/express/database/ and includes all the spatial features.


    Beginning Spatial with SQL Server http://www.apress.com/book/view/1430218290
    • Marked as answer by YEHOU Friday, June 11, 2010 2:12 AM
    Thursday, June 10, 2010 9:23 AM
    Answerer
  • The reason why I do not upgrade is that my company buys a 3rd party BI product which can only connect SQL Server 2005.

    Thank you.

    Friday, June 11, 2010 2:11 AM