Skip to main content
Geographic Information Systems

Return to Answer

added 1 characters in body
Source Link
thylacine
thylacine
  • 66
  • 6

I can write to SQL Server 2008 with GDAL 1.10.1 using below command. I'm using SQL Server auth entication and a user that has connect, create procedure, create table, create view, select and showplan. I suspect that I only need, connect and create table for below.

Although I have also had to delete the geometry columns and spatial ref system tables at times 'manually'. At the moment these do not exist but this command works.

U:\>ogr2ogr -overwrite -nln "LCCGIS.CAD_Parcels_JSON" -f "MSSQLSpatial" "MSSQL:server=SQL2008P1\MSSQLSERVER32BIT;database=GISTEST;Uid=lccgis;pwd=password" jsonURL -lco "DIM=2"

I can write to SQL Server 2008 with GDAL 1.10.1 using below command. I'm using SQL Server auth entication and a user that has connect, create procedure, create table, create view, select and showplan. I suspect that I only need, connect and create table for below.

Although I have also had to delete the geometry columns and spatial ref system tables at times 'manually'. At the moment these do not exist but this command works.

U:\>ogr2ogr -overwrite -nln "LCCGIS.CAD_Parcels_JSON" -f "MSSQLSpatial" "MSSQL:server=SQL2008P1\MSSQLSERVER32BIT;database=GISTEST;Uid=lccgis;pwd=password" jsonURL lco "DIM=2"

I can write to SQL Server 2008 with GDAL 1.10.1 using below command. I'm using SQL Server auth entication and a user that has connect, create procedure, create table, create view, select and showplan. I suspect that I only need, connect and create table for below.

Although I have also had to delete the geometry columns and spatial ref system tables at times 'manually'. At the moment these do not exist but this command works.

U:\>ogr2ogr -overwrite -nln "LCCGIS.CAD_Parcels_JSON" -f "MSSQLSpatial" "MSSQL:server=SQL2008P1\MSSQLSERVER32BIT;database=GISTEST;Uid=lccgis;pwd=password" jsonURL -lco "DIM=2"
Source Link
thylacine
thylacine
  • 66
  • 6

I can write to SQL Server 2008 with GDAL 1.10.1 using below command. I'm using SQL Server auth entication and a user that has connect, create procedure, create table, create view, select and showplan. I suspect that I only need, connect and create table for below.

Although I have also had to delete the geometry columns and spatial ref system tables at times 'manually'. At the moment these do not exist but this command works.

U:\>ogr2ogr -overwrite -nln "LCCGIS.CAD_Parcels_JSON" -f "MSSQLSpatial" "MSSQL:server=SQL2008P1\MSSQLSERVER32BIT;database=GISTEST;Uid=lccgis;pwd=password" jsonURL lco "DIM=2"