Hi,<br><br>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.<br>
<br>For an offline solution you might wan to convert your data to shapefiles and use the shapefile importer tool described at:<br><a href="http://www.sharpgis.net/post/2007/12/Shapefile-to-SqlServer-2008-to-WPF.aspx">http://www.sharpgis.net/post/2007/12/Shapefile-to-SqlServer-2008-to-WPF.aspx</a><br>
<br><br>Best regards,<br><br>Tamas<br><br><br><br><div class="gmail_quote">2010/3/11 Kiks <span dir="ltr"><<a href="mailto:enrico.oemi@gmail.com">enrico.oemi@gmail.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
I manage to install and import data to PostGIS.<br>
Now I'm trying to transfer data with ogr2ogr, but I have some problems to<br>
understand the syntax:<br>
<br>
I have a System ODBC data source called CG.<br>
I tried to run:<br>
ogr2ogr -f "ODBC:CG" -t_srs "EPSG:3003" PG:"host=localhost user=postgres<br>
dbname=osm password=postgres port=5432" -update -lco OVERWRITE=yes -nlt NONE<br>
<br>
But it is not accepted.<br>
I don't understand where I'm wrong<br>
<br>
thanks for your help,<br>
Kiks<br>
<font color="#888888">--<br>
View this message in context: <a href="http://n2.nabble.com/OSM2-SqlServer-2008-tp4716063p4717357.html" target="_blank">http://n2.nabble.com/OSM2-SqlServer-2008-tp4716063p4717357.html</a><br>
</font><div><div></div><div class="h5">Sent from the Mapserver - User mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</div></div></blockquote></div><br>