Support for SQL Server

The GeoServer team is happy to announce an extension for Microsoft SQL Server, currently available as a nightly build. Instructions for getting the extension up and running are available on the wiki.

At this point the extension is still quite young and is missing some key features like spatial indexing and support for well known binary. By trying it out and providing us with feedback you can help drive development of these features.

The extension is based on the recent re-architecture in GeoTools for database backed data stores. Code named “JDBC Next Generation”, it provides a framework for building new data store implementations quickly and robustly. Also based on this architecture are soon to come improved extensions for MySQL, Oracle, and DB2. A new extension for SpatiaLite is also in the works.

Download the SQL Server extension and try it out. We are very eager to here any feedback on the mailing list. You can also help us make it better by reporting any issues in our bug tracker.

This entry was written by Justin Deoliveira, posted on November 10, 2008 at 8:15 pm, filed under Announcements, Developer notes, Features. Bookmark the permalink. Follow any comments here with the RSS feed for this post.
Post a comment or leave a trackback:

click here to generate a trackback url
Note: trackback url expires in 15 minutes and may be used only once. Javascript is required!

6 Comments

  1. Mike Pumphrey
    Posted November 19, 2008 at 11:19 am | Permalink

    Just wanted to point out that this is specifically for SQL Server 2008, as this was the version where spatial support was added. So, for those using SQL Server 2000 or 2005, time to upgrade!

  2. Jasun Chang
    Posted December 29, 2008 at 10:06 pm | Permalink

    I am a new kid in the block. Is there a GeoJson Datastore extension for Geoserver? Thanks.

    Jasun

  3. Justin Deoliveira
    Posted December 31, 2008 at 1:41 pm | Permalink

    Jasun:

    There is no datastore extension for serving geojson sitting in a file on disk (or some other source). Only an output format for wfs to serve up data as geojson.

  4. Jasun Chang
    Posted December 31, 2008 at 10:47 pm | Permalink

    Justin,

    Thanks for the reply. Then, does geoserver provide a direct method or web service to create a new feature layer (such as buffer or intersection) without relying using command level GDAL commands or POSTGIS commands?

    Thanks.

    Jasun

  5. Justin Deoliveira
    Posted January 1, 2009 at 9:39 pm | Permalink

    Jason,

    Not really. Currently we are working on a Web Processing Service (WPS) implementation in GeoServer, but it is still in the experimental stages.

  6. Jasun Chang
    Posted January 2, 2009 at 10:31 pm | Permalink

    Justin,

    Thanks. Any time frame for the official release for the WPS. 2 months or 6 months? Any other suggestions?

    Your help is really appreciated.

    Jasun

3 Trackbacks

  1. By Suporte ao SQL Server no GeoServer » Fernando Quadro on November 13, 2008 at 10:42 am

    [...] Fonte: Blog do GeoServer [...]

  2. By Links (01.12.2008) « Geospatial Web on December 1, 2008 at 6:43 am

    [...] Support for SQL Server. GeoServer bietet neuerdings auch eine Extension zur Anbindung von Microsoft SQL Server. [...]

  3. By GeoServer 1.7.1 Released - GeoServer Blog on December 9, 2008 at 11:56 am

    [...] just improved Google Earth support.  GeoServer now has an official SQL Server extension (described previously). In addition, there is a new and improved Oracle extension which provides better performance and [...]

Post a Comment

Your email is never shared. Required fields are marked *

*
*
Download GeoServer