[mapserver-dev] MS SQL Server 2008 support?

Graham Davis gdavis at refractions.net
Mon May 25 14:41:50 EDT 2009


Thanks Paul.  Didn't realize there was a trial version.  Setting up an 
environment to test with now.

Graham.


Paul Ramsey wrote:
> 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
>>
>>     


-- 
Graham Davis
Refractions Research Inc.
gdavis at refractions.net



More information about the mapserver-dev mailing list