[postgis-users] The Old Who is using PostGIS survey again?
pramsey at cleverelephant.ca
Thu Jan 8 10:48:59 PST 2009
They do (or did) offer evaluation versions of the FME.
For your Oracle stored proc problem all I can offer is yet more costly
software. :) The EnterpriseDB "PostgresPlus" includes a complete
Oracle compatibility layer, which allows you to run PL/SQL in the
database and even connect using old SQL*Net clients.
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
>> 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
> Postgresql as a replacement for Oracle is to save money on licensing
> 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
> 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
> 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.
>> On Wed, Jan 7, 2009 at 12:36 PM, Stephen Carville <scarville at landam.com
>>> 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
>>> of us has a deep knowledge of GIS and database management. Right
>>> snap up a "dummies" book for postGIS in a heartbeat. I could use
>> 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
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> 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:
>> 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
pramsey at cleverelephant.ca
+1 250 885 0632
More information about the postgis-users