Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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?

share|improve this question
    
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

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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