1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is difference beteen Migration and Upgrdation?

Question Posted / phani kiran sai

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


Please Help Members By Posting Answers For Below Questions

What is the difference between an index and a unique index?

548

What is the use of @@spid?

576

What is difference between index and primary key?

593

Can you explain what is the use of custom fields in report?

603

Can we write trigger for view?

561




Explain primary key, foreign key and unique key?

548

How to include text values in sql statements?

593

What is report server project?

106

What is indexing in sql server with example?

525

What are the acid properties?

555

Comment,Datatypes are unlimited

1632

Explain what are the restrictions while creating batches in sql server?

591

Explain identity in sql server?

569

Differentiate between sql temp table vs table variable?

523

Is sql server implemented as a service or an application? : Sql server database administration

512