what are the different between database migration and database
upgration?

On Jan 18, 12:14*am, "hitgonora... (AT) gmail (DOT) com" <hitgonora... (AT) gmail (DOT) com>
wrote:
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 --

On Jan 18, 12:14*am, "hitgonora... (AT) gmail (DOT) com" <hitgonora... (AT) gmail (DOT) com>
wrote:
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 --

On Jan 18, 12:14*am, "hitgonora... (AT) gmail (DOT) com" <hitgonora... (AT) gmail (DOT) com>
wrote:
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 --

On Jan 18, 12:14*am, "hitgonora... (AT) gmail (DOT) com" <hitgonora... (AT) gmail (DOT) com>
wrote:
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 --