Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference beteen Migration and Upgrdation?
- 7 Answers
- 25314 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
What is truncate table?
plss anybody specify tha constrian management system in dbms
How ssrs maintain security?
What is the maximum size of a dimension? : sql server analysis services, ssas
What is NOT NULL Constraint in sql server 2012?
How to generate create function script on an existing function?
How to link tables in sql server?
What do you mean by data integrity?
What is the difference between index seek vs. Index scan?
What is the recovery model?
What is @@rowcount in sql?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
How to use group functions in the select clause in ms sql server?
What is an indexing technique?
Can you please explain the difference between function and stored procedure?
