[mapserver-users] Re: OSM2 SqlServer 2008

[Tamas Szekeres]

Hi,

It must be noted the OGR ODBC driver is read only at the moment, so you
cannot import data to SQL server by using ogr2ogr directly. Moreover to
support the SQL 2008 spatial data types further enhancements should be
implemented in the driver.

For an offline solution you might wan to convert your data to shapefiles and
use the shapefile importer tool described at:
http://www.sharpgis.net/post/2007/12/Shapefile-to-SqlServer-2008-to-WPF.aspx


Best regards,

Tamas



2010/3/11 Kiks <enrico.oemi at gmail.com>

>
> I manage to install and import data to PostGIS.
> Now I'm trying to transfer data with ogr2ogr, but I have some problems to
> understand the syntax:
>
> I have a System ODBC data source called CG.
> I tried to run:
> ogr2ogr -f "ODBC:CG" -t_srs "EPSG:3003" PG:"host=localhost user=postgres
> dbname=osm password=postgres port=5432" -update -lco OVERWRITE=yes -nlt
> NONE
>
> But it is not accepted.
> I don't understand where I'm wrong
>
> thanks for your help,
> Kiks
> --
> View this message in context:
> http://n2.nabble.com/OSM2-SqlServer-2008-tp4716063p4717357.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20100311/6e101914/attachment.html