What is difference beteen Migration and Upgrdation?
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
How would we use distinct statement? What is its use?
What is the web service used for reporting services?
how to invoke a trigger on demand? : Sql server database administration
List down some advantages of sql stored procedure?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How can we delete Duplicate row in table?
Define candidate key, alternate key, and composite key.
Do you know what is difference between stored procedure and user defined function?
How to insert data with null values?
How can we use ConnectorJ JDBC Driver with MS SQL?
What is server-level principal?
Name the different type of indexes in sql?
What are data resources?
How do I create a trace in sql server?
How to disable triggers using "disable trigger"?