[postgis-users] Transferring ArcSDE tables to PostGIS using FME

[Howard Butler]

/me runs away screaming at the thought of trigger hooking all of the  
add/deletes/modified tables of every SDE layer I wish to synchronize...

ogr2ogr is another option.  When compiled against the SDE SDK client  
libraries and PostGIS client, you can read SDE and write to PostGIS.

I'm still working on it, and it doesn't do too much yet, but PySDE  
might also be another option (patches graciously accepted!) <http:// 
sde.hobu.biz>.  With the proper wraps, you could check out what's in  
your deltas since the last layer state that you updated and only sync  
that.

You could also just do this yourself with some crafty c/c++ and the  
SDE SDK itself and skip all the wrapping insanity. Or, hire out an  
enterprising ArcSDE/OGR/GDAL developer to add state/version magic to  
OGR to do it there ;)

So, nothing immediate other than a few brute force approaches, but  
there are ways we can make SDE talk.... :)

Howard

On Jan 15, 2007, at 8:00 PM, Paul Ramsey wrote:

> If "several" tables are in the millions of records, then it could  
> take some hours, probably not all night though.  Transferring with  
> FME is not as fast as some of the bulk-loading strategies  
> available.  A popular trick is to attach some triggers to the  
> source tables to that they generate deltas as they are updated,  
> then only transfer the deltas nightly.
>
> On 15-Jan-07, at 12:18 PM, Brian Timoney wrote:
>
>>
>>
>> I'm looking for information from those who have had experience  
>> routinely copying ArcSDE tables to PostGIS using FME.   
>> Specifically I have a client mulling the feasibility of batch  
>> scheduling a transfer of tables on a nightly basis.  While I've  
>> been told that's a fairly straightforward process, some of the  
>> tables are large-ish (e.g. a point file with 2 million records)  
>> and I don't have any idea whether the transfer time would be in  
>> the minutes, tens of minutes, or hours.  Of course I understand  
>> much of it depends on hardware specs, but having a general sense  
>> of what orders of magnitude we're talking would be helpful.
>>
>>
>> Thanks,
>>
>> Brian
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>