Tell me more ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite

i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but while searching i found other tools (like : artend, data migration tool kit, ETL integrator, Scriptella ...). Now i am confused, i don't know what to choose amoung many open source and licenced solution. Plz help.

share|improve this question
1  
Not really sure what the question is since you had success with FME (which is an excellent tool), but you could try the Shapefile Loader that comes with SQL Server Spatial Tools. – Chad Cooper Feb 6 at 15:06
2  
What is wrong with FME Desktop? - We use it exclusively for moving large amounts of data [CAD/DGN or Other formats] into Oracle/SQL Server on daily basis. It is worth the purchase and support responsive - first class service. – Mapperz♦ Feb 6 at 15:09
FME Desktop is not free and the trial period is too short. i tried the shapefile uploader but the data was not uploaded in my database, also i found on the internet that the shapefile uploader do not deal with large amount of data. and since am working as a trainer on the agency of cadastrial data and cartography i need an excellent tool (preference open source) for moving data. Thank you – Asma.O Feb 6 at 15:39
we have 30,000 cad files and 40,000 shapefiles all loading into oracle without issue from suppliers ftp site. Are you using Workbench or the universal translator? FME can be a steep learning curve for the untrained. – Mapperz♦ Feb 6 at 17:36
am generating workbench – Asma.O Feb 6 at 22:19

1 Answer

up vote 1 down vote

try to use open-source program brigantine to migrate shapefiles to SQL SERVER

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.