Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference beteen Migration and Upgrdation?
- 7 Answers
- 25120 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / phani kiran sai
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 |
Post New Answer View All Answers
Explain alternate key, candidate key and composite key in sql server?
How to Update from select query in sql server?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to enter unicode character string literals in ms sql server?
what happens on checkpoint? : Sql server database administration
What is the difference between primary key and unique constraints?
What is b tree index?
What is normalization? Describe its different types.
Do you have any idea about the tcl commands?
Explain about Joins?
What are three major types of constraints?
How to create new tables with "select ... Into" statements in ms sql server?
How do you improve the performance of a SQL Azure Database?
what type of index will get created after executing the above statement? : Sql server database administration
What is the difference between resultset and resultsetmetadata?
