I have a few tables with geometry fields in MsSQL Server 2008. I would like to export the whole table with data to MsSQL Server. Are there any open source/free tools that does this job?

  • can you use ogr2ogr?
    – Nathan W
    Mar 10 '13 at 3:04
  • ogr2ogr supports all kinds of stuff? i will try out now..
    – vinayan
    Mar 10 '13 at 3:05

ogr2ogr -f MySQL MySQL:test,user=root MSSQLSpatial "MSSQL:server=.\MSSQLSERVER2008;database=geodb;trusted_connection=yes"

See the documentation for the syntax http://www.gdal.org/ogr/drv_mysql.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.