How to import shape files into SQL Server?

How to import shape files into SQL Server?

In the past I have used shape2sql to import shape files into SQL Server. I tried that route again on a newer Windows 10 box, and nothing seems to happen when trying to use that application. Any suggestions for either getting shape2sql to work, or alternative ways to upload shape files into SQL Server?

How to export ogr2ogr patterns to SQL Server?

The following code exports data from the OGRExportTable in the localhost\\sqlexpress SQL Server instance to an ESRI Shapefile called c: emp\\sqlexport_linestring.shp . ESRI Shapefiles can only contain features of a single geometry type.

How to upload shapefile to Azure SQL Server?

To upload a shapefile to a local or remote Microsoft SQL Server database (or Azure SQL) using GDAL’s ogr2ogr, open a new command prompt and use this: Note that the default port for SQL Server databases is 1433.

How is geometry data assigned in ogr2ogr?

The geometry data is assigned the projected SRID EPSG:2249 (assumed to be the SRID in which the source data is supplied, but this is not checked by OGR2OGR). The following code listing takes data from the precincts.shp ESRI shapefile and loads it into the sql2012 SQL Server instance running on localhost .

How to import shapefile in SQL Server ogr2ogr.exe?

My syntax was (from the command prompt in the directory that ogr2ogr.exe is in): Note: the “trusted connection” parameter is used when you are using windows authentication (e.g., when you are on a domain network) as MSSQL login credentials.

How big is a shapefile in SQL Server?

The shapefile I was dealing with was at a very granular level (which means that it had a lot of data, 2.5 MB in size), and we needed to do some custom aggregations on the spatial data. As the custom aggregations were done at report run time, it turned out to be a major performance bottleneck.

Can You import ogr2ogr files into SQL Server?

So, it turns out that ogr2ogr has the ability to import directly into a SQL Server database now. I created a temporary database and did the following: I’ve managed to import successfully on remote server.

How to aggregate geometry data in SQL 2012?

SQL 2012 has integrated these features and hence if you are using SQL 2012, you can aggregate both geography and geometry data types using the built in functions Geometry::UnionAggregate (geom) and Geography::UnionAggregate (geog). Refer the blog below http://social.technet.microsoft.com/wiki/contents/articles/4136.aspx