We're currently in the process of evaluating pgSQL to migrate from
Oracle, which is our enterprise rdbms.
Would you guys have any white paper or any documents that lists how big
companies handled their deployment, e.g. (1) is it advisable to give
training classes to application development team, if yes, how could we
get these services and who should we contact?; (2) do you have a "cheat
sheet" of all of the essential things needed to quickly port from Oracle
to pgSQL?; (3) how would the information be disseminated to all of the
other parties involved (i.e., QA, networking, operations)?; (4) what are
the best practices for setting up the dev, qa test, and production
environments; etc.
I believe that small companies don't need to have such a grand plan to
do the migration because there's normally not a lot of red tape to go
through. I know this, coming from a start-up internet company before,
where we setup everything ourselves and quickly rollout things to
production. But that's not the case for me now.
Maybe pgSQL commercial vendors would do this for a corporation for a fee
but if you know of anything that's available that's posted for free,
that'll be great!
I went through the techdocs site and didn't find anything.
Thanks so much!
- Lily Anne
