What is difference beteen Migration and Upgrdation?
- 7 Answers
- 23696 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
How to find the source of a table in sql server?
What is the use of keyword with encryption. Create a store procedure with encryption?
How to connect to SQL Azure Database by using sqlcmd?
Explain the difference between function and stored procedure?
How to override dml statements with triggers?
What is the difference between NOROW and LOCKROW?
What is the usage of the sign function?
What is row_number()?
How to insert multiple rows with one insert statement in ms sql server?
Tell me what is the difference between locking and multi-versioning?
What are the differences between union, intersect, and minus operators?
Explain how dts is used to extract, transform and consolidate data?
Can you explain what are commit and rollback in sql?
What Is Rdbms?
List the different index configurations possible for a table?
