Re: [mapserver-users] Will Mapserver work with newer Microsoft SQL Server Spatial Databases
Dear Seth, Thanks so much for sharing your experiences. Also that it works well is great. The naming of the driver thus does not reflect that it does suports more than only version 2008 ;) Hope this answer will help out others as well. Cheers Karsten -Original Message- From: Seth G [mailto:se...@geographika.co.uk] Sent: Tuesday, February 07, 2017 12:18 To: kars...@terragis.net; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Will Mapserver work with newer Microsoft SQL Server Spatial Databases Hi Karsten, We were running a production system with MS SQL 2012 for 4 years without any problems. We briefly moved to SQL 2014, and are now on SQL 2016 again without issues. Tamas Szekeres does a great job of maintaining and improving the MS SQL driver - https://github.com/mapserver/mapserver/blob/master/mapmssql2008.c The OGR driver also works, but I found it to be much less flexible in terms of complex SQL and adding filters. Regards, Seth On 07/02/2017 21:12, karsten wrote: > > Dear All, > > I am trying to find out if MapServer (and/or OGR) will work with > spatial databases newer than Microsoft SQL Server 2008. I know that > the drivers work with that older version but did not want to promise > to a client that it would. At this point I am not able to test it > directly because I do not have access to a Microsoft SQL Server 2012 or newer to verify. > Does anyone have experience and succeed with this or anyone who can > share their experiences ? > > Cheers > Karsten > > www.terragis.net > > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Will Mapserver work with newer Microsoft SQL Server Spatial Databases
Hi Karsten, We were running a production system with MS SQL 2012 for 4 years without any problems. We briefly moved to SQL 2014, and are now on SQL 2016 again without issues. Tamas Szekeres does a great job of maintaining and improving the MS SQL driver - https://github.com/mapserver/mapserver/blob/master/mapmssql2008.c The OGR driver also works, but I found it to be much less flexible in terms of complex SQL and adding filters. Regards, Seth On 07/02/2017 21:12, karsten wrote: Dear All, I am trying to find out if MapServer (and/or OGR) will work with spatial databases newer than Microsoft SQL Server 2008. I know that the drivers work with that older version but did not want to promise to a client that it would. At this point I am not able to test it directly because I do not have access to a Microsoft SQL Server 2012 or newer to verify. Does anyone have experience and succeed with this or anyone who can share their experiences ? Cheers Karsten www.terragis.net ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Will Mapserver work with newer Microsoft SQL Server Spatial Databases
Dear All, I am trying to find out if MapServer (and/or OGR) will work with spatial databases newer than Microsoft SQL Server 2008. I know that the drivers work with that older version but did not want to promise to a client that it would. At this point I am not able to test it directly because I do not have access to a Microsoft SQL Server 2012 or newer to verify. Does anyone have experience and succeed with this or anyone who can share their experiences ? Cheers Karsten www.terragis.net ___ mapserver-users mailing list mapserver-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapserver-users