Saturday, September 3, 2011
Difference Between Upgradation and Migration in Oracle
Upgradation : Upgrade is the process of replacing our existing software with a newer version of the same product. For example, replacing oracle 9i release to oracle 10g release . Upgrading our applications usually does not require special tools. Our existing reports should look and behave the same in both products. However, sometimes minor changes may be seen in product .Upgradation is done at Software level.
Migration : Migration is the process of replicating applications from one product in another product, for example, transforming existing oracle 9i applications to oracle 10g applications.A migration is any change that transforms our hardware and/or software architecture to a new state. Migration is done as database level(say migrating from DB2 to Oracle).