Skip to main content
Geographic Information Systems

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • +1 for a very clear and helpful response. Even being complicated, it is a direct path. Commented Aug 3, 2011 at 0:57
  • In theory i like the idea of doing a direct DB transfer but i'm looking for something 'billy basic'. However we are SDE 9.3.1 at the mo, therefore the above answer isn't a go'a. As i say i'm new to PostGIS and SQL but i would have thought that there was a script 'out there' where by you could automate a bulk upload! Commented Aug 4, 2011 at 18:00
  • 1
    The other "DB->DB" option for all versions of SDE (and hundreds of other formats/DBs) is FME. FME is non-free (there is a free trial you can test out), which means they can provide support to help your synchronization solution. But this obviously requires a budget. The best free option is to tailor a good BAT script with shp2pgsql, psql, etc. Commented Aug 4, 2011 at 22:32
  • 2
    One of reasons I wrote the ArcObjects GDAL driver was to do exactly this. Since they have an ESRI license, the wanted to maintain their complex FeatureClasses and dump them to PostGIS every night. The arcsde driver goes through the arcsde api layer, but the arcobjects driver goes, well, through arcobjects. We have been using it for a year and it has worked quite nicely. Commented Aug 6, 2011 at 22:25
  • Where you get the "SDE" driver so you can use that existing Python script? I can't find... Commented Oct 16, 2015 at 15:35