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.

  • 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 '13 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 '13 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 – Geographic Feb 6 '13 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 '13 at 17:36
  • am generating workbench – Geographic Feb 6 '13 at 22:19

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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