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