[mapserver-dev] MS SQL Server 2008 support?

[Paul Ramsey]

Graham,

For bonus points, when you get some answers about how different
packages suck/don'tsuck WRT sqlserver, write up a blog post or just a
summary post to the mapserver/geoserver lists so that others can get
benefit from your tests (you may also find that if you screwed up your
tests in some way you also get feedback ("no, no, first you sacrifice
the chicken *then* you sprinkle the newts eyes")).

Yours,

P.

On Mon, May 25, 2009 at 11:41 AM, Graham Davis <gdavis at refractions.net> wrote:
> 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
>
>