What is difference beteen Migration and Upgrdation?

Answer Posted / thrilok

Migration is the process of taking the backup and restore into the target server (One or More).
Down time is not mandatory.
Man power is required.

Upgradation is the process of replacing the old version of sql server with the new version of sql server.
Down time is mandatory for upgradation.
Man power is not required.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

‘Order by’ is not allowed in a view how can you sort information from a view?

666


Why SQL Agent is used?

659


How can you find out how many rows returned in a cursor?

625


Can primary key be null?

575


How sql server enhances scalability of the database system?

661






What is snapshot replication?

659


What is an indexing strategy?

598


What is an expensive query?

597


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

664


What is pivot and unpivot?

690


How do I create an extended event in sql server?

550


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

807


Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

564


Can we perform backup restore operation on tempdb?

631


What is sql azure database?

190