Re: what are the different between database migration and database upgration?
Date: Fri, 18 Jan 2008 10:33:33 -0800 (PST)
On Jan 18, 12:14 am, "hitgonora..._at_gmail.com" <hitgonora..._at_gmail.com> wrote:
> what are the different between database migration and database
The exact meaning of many terms depends on the speaker and context.
Technically the term database migration should refer to when you move (migrate) a database from one physical database to another physical database possibly on a different platform (or server).
An upgrade is when you take the necessary action to be able to start the existing database on a higher version of the software than it is currently running on.
You can perform the two tasks at the same time or as part of the same process.
The terms are often interchanged but should not be based on the English language meaning of migrate: to move from one place to another (Second College Edition, New World Dictionary).
The old Oracle migration utility bears some of the blame for confusing terminology since it was required to be ran to perform an upgrade on an existing database data file headers for one release to another back in 7.1 to 7.2 or 7.2 to 7.3 days. I cannot remember any more when you had to use it to upgrade.
HTH -- Mark D Powell -- Received on Fri Jan 18 2008 - 12:33:33 CST