What is difference beteen Migration and Upgrdation?
- 7 Answers
- 23334 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 data regions?
How efficient you are in oracle and SQL server?
How to convert character strings into numeric values?
How do I view a trc file?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
How to execute a sql statement using odbc_exec()?
What is user-defined functions? What are the types of user-defined functions that can be created?
How can we migrate from SQL server to SQL Azure?
How to start and end transact-sql statements?
Ways to improve the performance of a SQL Azure Database?
How to delete multiple rows with one delete statement in ms sql server?
How do I setup a sql server database?
What is trace flag in sql server?
Explain comment on transactions?
What is the difference between deallocate cursor and close cursor?
