Look in:

Web oracle-core-dba.blogspot.com

Friday, March 24, 2006

Migration versus Upgrade

Migration versus Upgrade

An upgrade is limited to installing a new release of the application software and does not include changes to the technical architecture. It can include revising business processes and updating (or eliminating) custom extensions.

A migration is any change that transforms your hardware and/or software architecture to a new state. Therefore, a software upgrade is a type of migration, but is limited in scope and impact. A migration can include moving to a new hardware environment or user interface environment in addition to an application software upgrade.

A common day example of the difference between Upgrade and Migration is as follows:
“Suppose you have a house and wish to improve it. You have 2 choices: Either to make adjustments to the existing building, for example, painting it or adding a new storey to it (this is upgrading) or to construct a completely new house independent of the previous house (this is migration).”

In terms of Database the definitions are as below

Upgrade: Migration:
Changes the minor release number Changes the major release number
Example: 8.1.7.0.0 to 8.1.7.4.0 Example: 8.1.7.0.0 to 9.0.2.0.7
Usually modest change to data dictionary Changes control file and data file headers
Reversible, that is, we can uninstall- Cannot be reversed withoutrestoring a backup
the version and revert back to original
release number

No comments: