[mapserver-dev] MS SQL Server 2008 support?

[Paul Ramsey]

Graham,

You can download SQL Server Express 2008, which includes the spatial
option (all versions of 2008 do).
http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx

The source code also tells you that indexes are used:

http://trac.osgeo.org/mapserver/browser/tags/rel-5-4-0/mapserver/mapmssql2008.c#L631

And the binary transmission is used:

http://trac.osgeo.org/mapserver/browser/tags/rel-5-4-0/mapserver/mapmssql2008.c#L556

You've been asking variants of this question on IRC, too. Download,
compile, try.

P.

On Mon, May 25, 2009 at 11:29 AM, Graham Davis <gdavis at refractions.net> wrote:
> Hi,
>
> I am looking at MS SQL Server 2008 support in Mapserver for a client.  They
> currently don't have SQL Server 2008 (so I am unable to test) but they are
> interested in how well it is supported with Mapserver.  I know that other
> servers like GeoServer only have very basic support for this database so far
> (no support for spatial indexes or WKB).  How complete is Mapserver's
> support of this database?
> I've seen this plugin:  http://mapserver.org/development/rfc/ms-rfc-38.html
>  and understand this is the only SQL Server support so far.  Is that
> correct?  Are there any known issues or unsupported parts of SQL Server 2008
> spatial with this plugin?
>
> Thanks in advance,
>
> --
> Graham Davis
> Refractions Research Inc.
> gdavis at refractions.net
>
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>