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

[Stephen Carville]

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