December 27, 2010 at 11:58 pm
I have tried to use the tool from this site but it does not import, no errors, just fails, and no source code.
http://www.sharpgis.net/post/2007/12/Shapefile-to-SqlServer-2008-to-WPF.aspx
I have an ESRI shape file for regions around new zealand.
It is pretty simple with only 17 shapes.
The original shape file is from http://koordinates.com/ for Boundaries and Administration for New Zealand. I am after
NZ Regional Councils (2008 Yearly Pattern)
This is a 4MB file to download.
But I do not know how to get this into SQL Server. When using the SharpGIS import tool it says it is importing, shows no errors, but does not generate anything in the database.
If anyone knows any tools that would be very much appreciated.
Cheers
Chris
December 28, 2010 at 1:55 am
try use ssis
December 28, 2010 at 11:22 am
roi.reuven (12/28/2010)
try use ssis
Anything more specific than this?
Is there some specific object I can use? Can you point me to an article online?
chris
December 28, 2010 at 11:17 pm
try watch tis webcast
http://www.sqlis.com/sqlis/post/Sorting-data-in-the-SSIS-Pipeline.aspx
December 29, 2010 at 12:20 am
I think you are on the wrong track there.
I am trying to convert a GIS SHAPE FILE to SQL SERVER Data.
Saying I should watch a SSIS video on sorting inputs seems rather off topic to me. I want to import data which is what SSIS is for, but I have a GIS SHAPE File which as far as I know there is no SSIS provider to read such data.
Chris
December 29, 2010 at 12:33 am
try read this
How to import shapefiles into SQL Server 2008 via SSIS
http://social.msdn.microsoft.com/Forums/en/sqlspatial/thread/81e16acd-4c5a-4b78-8592-fdc73df3c40e
December 29, 2010 at 1:20 am
please give feadback if this help you or not
December 29, 2010 at 11:20 am
While I am not aware of any reason why the the SharpGIS Shp2SQL program is not working for you, another good choice is Safe Software's Feature Manipulation Engine (FME). While the full version of FME is fairly expensive, they have a new US$500 version, the FME SQL Server Loader Edition, which will do the jog and then some. The "then some" refers to additional transformers, such a map/datum transformation support (etc.), which make this package an extremely good value. See http://www.safe.com/microsoft for more information.
December 29, 2010 at 11:54 am
ed.katibah (12/29/2010)the FME SQL Server Loader Edition, which will do the jog and then some.
Hi
Thanks for the info on the FME SQL Server Loader Edition - but I do not know how to download it. Is it just part of the 14 day trail of FME Desktop? Which is like 440MB a bit of overkill to import a simple shape file of 4MB.
I see it mentioned on the page you gave but no download link and nothing more about it. Just the full desktop version available as a trial.
Cheers
Chris
December 29, 2010 at 11:55 am
roi.reuven (12/29/2010)
please give feadback if this help you or not
The code project that was mentioned in the thread has given me some ideas - so I appreciate that.
The link for that is http://shapefile.codeplex.com/
Cheers
Chris
January 10, 2011 at 1:13 pm
You can locate the FME Desktop evaluation at: http://www.safe.com/products/fme-desktop/trial-download/ - and yes, it's just a single download and includes the full functionality of our more extensive SQL Server edition (as opposed to just the loader capabilities).
We also delivered a webinar on how to load data into SQL Server in December. You can view the recording by clicking the link on the right hand side of this page:
http://www.safe.com/solutions/for-products/microsoft-sql-server/
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply