[gdal-dev] Import Shapefile into SQL Server on Ubuntu

[Peter Marlow]

Hi,

I'm trying to import a Shapefile into an SQL Server database using ogr2ogr on Ubuntu. The command I'm running looks like:

ogr2ogr -f MSSQLSpatial "MSSQL:server=localhost;database=[database-name];username=sa;password=*****;trusted_connection=yes" [path-to-shape-file]

It returns an error stating:

ERROR 1: Unable to find driver `MSSQLSpatial'.

Is it possible to get the driver on linux? Or use an alternative driver? I've had a google and can't seem to see any workarounds.

The docs here (https://www.gdal.org/drv_mssqlspatial.html) talk about specifying a Driver parameter that could be a custom SQL Server driver, however this is in the connection string and not as a parameter for the ogr2ogr command.

Thanks,
Pete



SCISYS UK Limited. Registered in England and Wales No. 4373530.
Registered Office: Methuen Park, Chippenham, Wiltshire SN14 0GB, UK.
 
Before printing, please think about the environment.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20181022/70491236/attachment.html>