What is difference beteen Migration and Upgrdation?
Answers were Sorted based on User's Feedback
Answer / cxvxvxvxv
The above answer is a bloody answer...people cant even
understand that...plz if u dont know da answer dont
reply...answer it only if u know....
Migration is the process of Copying or exporting the data
from one server to the other..
Upgradation is the process of replacing the old version
with the new version....
Is This Answer Correct ? | 58 Yes | 2 No |
Migration:
There are various situations for migration
1. LAUNCH, GO-LIVE, DEPLOYMENT.
A situation or a birth of PROJECT is known as LAUNCH,
GO-LIVE, DEPLOYMENT. Starts from Development -> Test ->
Production.
2. DB-REFRESH.
When we need to take back the server and its functionalities
from PRODUCTION SERVER to TEST SERVER and back again to
PRODUCTION SERVER is known as DB-REFRESH.
3. MOVING FROM OLD HARDWARE TO NEW HARDWARE.
Every hardware is subject to END OF LIFE. In such
situations, we would move the entire server from OLD
HARDWARE to NEW HARDWARE.
4. MOVING BETWEEN DIFFERENT DATA CENTERS.
5. CONSOLIDATION PROJECT.
CONSOLIDATION is a process of gathering all the NON-CRITICAL
databases over individual servers and managing them in a
single high scalable server.
FROM THE ABOVE SITUATION, WE CAN CLEARLY IDENTIFY THAT WE
ARE NOT EFFECTING THE VERSION OF THE SQL SERVER SOFTWARE.
Up-gradation:
UP-GRADATION is a process of INSTALLING a newer version on
the existing SQL SERVER SOFTWARE. [E.G HOTFIX, PATCH,
SERVICE PACKS, VERSION UPGRADE]
There are two types of UP-GRADATION
1. IN-PLACE UP-GRADATION
2. SIDE-BY-SIDE UP-GRADATION
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / pavan
I can say simply.. Migration is the database level..moving the data of db from one server to another or from one environment to another..
Upgradtion is the instance level ..replacing old version with new version. Ex: SQL server 2005 to SQL server 2012.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / thrilok
Migration is the process of taking the backup and restore into the target server (One or More).
Down time is not mandatory.
Man power is required.
Upgradation is the process of replacing the old version of sql server with the new version of sql server.
Down time is mandatory for upgradation.
Man power is not required.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / sudharshanan
Migration is a tool comes with OS CD or DVD. It is used to
copy the settings like wallpaper,mails,regional options
from old computer to new computer. Most widely it is used
in big MNC's companies .
Upgrdation is a process of updating the OS through Internet
or patches. The group of patches is called Updates. The
group of update is called service packs or versions.
Is This Answer Correct ? | 1 Yes | 5 No |
Answer / nitin yadav
I know that if u change your sqlplus from 9.2.0.1 to 9.2.0.2
so this is migration.
and chnage from 9.2.0 to 10.2.0 so this is upgradation in
oracle
Is This Answer Correct ? | 2 Yes | 8 No |
Answer / karthikeyan.s
Migration is a already used it and same as uses another one.
Upgrdation is a latest versions i.e example for Windows is
an Upgrdation.
Is This Answer Correct ? | 5 Yes | 25 No |
What is join query?
What is the maximum rows in sql server table?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What are the transaction properties?
What is the difference between functions and stored procedures?
Is the primary key column of a table an index in ms sql server?
How to grant a permission in ms sql server using "grant execute" statements?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is sql server management studio? : sql server management studio
What is difference between inner join and join?
Can two tables have the same primary key?
What is a heap?