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

[Roger André]

See if this helps -
https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017
.

On Mon, Oct 22, 2018 at 8:25 AM Peter Marlow <Peter.Marlow at scisys.co.uk>
wrote:

> 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
>
>
>
> <http://gfidisc.scisys.co.uk>
>
>
> 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.
>
> <http://gfidisc.scisys.co.uk>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20181022/8256579e/attachment-0001.html>