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 3 down vote favorite

am trying to migrate PostGIS geometry to SQL server Spatial data. which ETL i have to use. it's the first time i'll work with SQL server Spatial. is there any Data ETL model that do this migration. thanks for help

share|improve this question
There are multiple ETL applications mentioned here: Spatial ETL comparisons – RyanDalton Feb 5 at 16:18

2 Answers

up vote 3 down vote

You can try

  • pgsql2shp (shapefile intermediate) and then use the sqlspatialtools to load
  • OGR2OGR supports reading and writing at both ends of that pipe
  • part of me wants to suggest that a PG_DUMP to text would provide SQL that could then be consumed in SQL server.

Details click here

share|improve this answer
okay thank you for your answer – Asma.O Feb 5 at 13:02
I found on the net the FME tools. is it the better way to transform my data ? – Asma.O Feb 5 at 13:07
1  
Asma.O yes FME is worth the money - look into FME Desktop Workbench , there are plenty of youtube videos on it. example youtube.com/playlist?list=PL111C94B34DBE7364 – Mapperz♦ Feb 5 at 14:32
ok thank you, yes it worth money but i'll try the trial version, waiting for it to download. @Sunil , am trying to use sqlspatialtools specially the shapetoSQL tool using the shapefile uploader for sql server, but i don't know what to choose either planar geometry or geography (spheric). what's the difference? do i have to choose planar geometric, because am not working in a continental-scale (data are limited to morocco) – Asma.O Feb 5 at 16:49
1  
@Asma.O sorry for my late reply.. I am using Geography type but for more information please check following link stackoverflow.com/questions/4991827/… – Sunil Feb 6 at 5:15
show 2 more comments
up vote 1 down vote

try to use program brigantine to migrate PostGIS geometry to SQL server Spatial data

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.