2

I am using design data from *.dwg and *.dgn to insert geometries to SQL Server field which is set to geometry. All examples I see are using something called WKT which is a specification by a company called OGC but they do not offer any converters so not straightforward to convert from *.dwg / *.dgn to prepare the insert statement.

Is there a different way to the WKT syntax to insert into SQL Server?

1

Microsoft doesn't support input from foreign formats. However, you can use GDAL's ogr2ogr to convert foreign formats representing Simple Features to a MSSQL import

More info:

To ease upgrading in the future to Ubuntu, you can install ogr2ogr with only

sudo apt-get install gdal-bin

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.