[postgis-users] The Old Who is using PostGIS survey again?

[Paul Ramsey]

Another option is ogr2ogr <http://www.gdal.org/ogr/> which should  
allow you to do flat table transfers.

P.

On Jan 8, 2009, at 10:30 AM, Stephen Carville wrote:

> On Wednesday 07 January 2009 15:34, Paul Ramsey wrote:
>> Fastest way to migrate: drop a couple thousand bucks on an FME  
>> license
>> and run it once. :)  If you understand Oracle Spatial, you understand
>> PostGIS, conceptually. Just a few function names different. The
>> drudgery of a migration though, that's something FME can cure.
>
> Thanks for the advice.  However the only reason the PTB's are even  
> considering
> Postgresql as a replacement for Oracle is to save money on licensing  
> and
> support costs.  There won't be any money for new software until at  
> least June
> by which time I hope to have a working system in test.  I'll check  
> and see of
> they have a demo version I can use for the test migration.  It's  
> only about
> 85G of data.
>
> If the GIS migration works out I might get the go ahead to test the
> transactional DB on Postgresql next year.  That  will be a bigger  
> "challenge"
> because of the number of stored procedures involved.  If there is a  
> tool that
> will make migrating those from Oracle to Postgresql I might just buy  
> it
> myself :-)
>
> There are other services I need to duplicate too such as replication
> (dataguard) and hot backups (rman). I will try not to be too much of a
> nuisance here or the pgsql-admin list.
>
>> P.
>>
>> On Wed, Jan 7, 2009 at 12:36 PM, Stephen Carville <scarville at landam.com 
>> >
>>
>> wrote:
>>> We're not there yet but one of the developers and I just started a
>>
>> project to
>>
>>> migrate our Flood zone data from  Oracle spacial to postGIS.
>>>
>>> I am a systems engineer; the other guy is a C and Java developer and
>>
>> neither
>>
>>> of us has a deep knowledge of GIS and database management.  Right  
>>> now
>>
>> I'd
>>
>>> snap up a "dummies" book for postGIS in a heartbeat.   I could use  
>>> any
>>
>> help I
>>
>>> can get :-)
>>>
>>> --
>>> Stephen Carville <scarville at landam.com>
>>> Systems Engineer
>>> Land America
>>> 1.626.667.1450 X1326
>>> ============================================================
>>> Any security software design that doesn't assume the enemy
>>> possesses the source code is already untrustworthy.
>>>                                          -- Eric Raymond
>>> _______________________________________________
>>> 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
>>
>>
>> No virus found in this incoming message.
>> Checked by AVG - http://www.avg.com
>> Version: 8.0.176 / Virus Database: 270.10.4/1880 - Release Date:  
>> 1/7/2009
>> 8:49 AM
>
> -- 
> Stephen Carville <scarville at landam.com>
> Systems Engineer
> Land America
> 1.626.667.1450 X1326
> ============================================================
> Any security software design that doesn't assume the enemy
> possesses the source code is already untrustworthy.
>                                           -- Eric Raymond
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


--
Paul Ramsey
pramsey at cleverelephant.ca
+1 250 885 0632