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

What does the update command do?

617


What is policy management?

585


How to include date and time values in sql statements?

634


In case you have filters in your report, when filters will be applied in cached report instance?

81


What are character string data types in ms sql server?

639






What do you mean by recursive stored procedure?

513


Explain difference between cross join and full outer join?

565


What are the properties of sub-query?

585


What are the steps you should follow to start sql server in single-user mode?

490


What do you understand by SQL*Net?

617


What is the difference between Clustered and Non-Clustered Index?

603


How to disconnect from a sql server using mssql_close()?

591


How to make a remote connection in a database?

535


What are diverse clauses that form a part of sql?

602


What is partition in sql server?

536