Over the next several months, we expect widespread adoption of OWB 11gR2, both for its new features and because it is the only release of Warehouse Builder certified for use with database 11gR2. Customers seeking to move existing environments to OWB 11gR2 should review the new whitepaper, OWB 11.2: Upgrade and Migration Paths.

This whitepaper covers the following topics:

• The difference between upgrade and migration, and how to choose between them
• An outline of how to perform each process
• When and where intermediate upgrade steps are required
• Tips for upgrading an existing environment to 11gR2 without having to regenerate and redeploy code to your production environment.

Moving up from 10gR2 and 11gR1 is generally straightforward. For customers still using OWB 9 or 10.1, it is generally possible to move an entire environment forward complete with design and runtime audit metadata, but the upgrade process can be complex and may require intermediate processing using OWB 10.2 or OWB 11.1. Moving a design by itself is much simpler, though it requires regeneration and redeployment.

Relevant details are provided in the whitepaper, so if you are planning an upgrade at some point soon, definitely start there.