current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Sign up ×
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
1

How to use MS SQL Server 2012 spatial database in postgresql using foreign data wrapper?

share|improve this question

1 Answer 1

up vote -1 down vote accepted

You can use Spatial Manager Desktop to export from SQL Server 2012 Spatial to PostGIS.

There is currently a free beta version ,you can download it here: http://www.spatialmanager.com/downloads/

If you need help on this feel free to tell me.

Disclaimer: I work for Opencartis (Spatial Manager developers)

share|improve this answer
    
Does this do a full data copy of the MSSQL DB to PostGIS, or does it work via foreign data wrappers? –  til_b Apr 16 '14 at 11:47
1  
You could also use ogr2ogr or FME from safe.com to do data import/export operations. There isn't even a non-spatial FDW wrapper for SQL server, let alone a spatial one. wiki.postgresql.org/wiki/Foreign_data_wrappers –  Paul Ramsey Apr 18 '14 at 1:17
    
Dear @Borja Arrue Is there any tutorial to connect postgres and mssql using spatial manager desktop? –  Vikram May 6 '14 at 4:12

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.