Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference beteen Migration and Upgrdation?
- 7 Answers
- 25087 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 are relationships and mention different types of relationships in the dbms
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What are the types of indexing?
What are ddl triggers and types of ddl trigger?
What is a data collection table?
What are the drawbacks of reporting in ssrs?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What it means to be triggered?
what stored procedure can you use to display the current processes? : Sql server administration
How to restore performance issues and how to check?
What is the difference between mysql and sql server?
Explain “not null constraint” in sql server?
What are the advantages of partitioning?
How to Check if table exists in sql server?
Explain different types of self contained sub query?
