Skip to content

A tool used for importing ESRI shapefiles to MS SQL Server

License

Notifications You must be signed in to change notification settings

vikovacheva/ShpToSqlServer

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ShpToSqlServer

A tool used for importing ESRI shapefiles to MS SQL Server

Here's a little tool for you that I've been using quite often lately. It can be used used to import Esri shapefiles into Microsoft SQL Server (2008 and 2012) while taking into account character encoding of the input data. The geospatial information is stored as SqlGeometry.

Nice thing about it is that it allows you to rename/remap destination table column names, choose the destination table name, and set the primary key for the table. And yeah, it has a user interface :)

The app is rather simple so I don't think that further explanation about its usage is needed. If it turns out that I've been wrong, don't hesitate to leave a comment.

I would like to point out one thing though. If you are not sure which encoding codepage to use, check this link and look it up. The codepage default is 65001, which is the code page for UTF-8 encoding. If you have any suggestions about improving the tool, or find a bug or something, leave a comment, I will be glad to update it.

About

A tool used for importing ESRI shapefiles to MS SQL Server

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C# 100.0%