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 is spatial nonclustered index

720


Explain the working of sql privileges?

797


What does indexation mean?

694


Who is the owner of a schema in ms sql server?

720


Explain what is scheduled job and how to create it?

716






Explain what is lock escalation?

766


What is Transparent Data Encryption?

731


what's the information that can be stored inside a bit column? : Sql server database administration

721


What is raiseerror? What is raiseerror?

799


What are different types of views?

698


What are the different type of replication in sql server?

737


Define full outer join?

700


What is sub-query in sql server?

878


What is an etl file?

699


What is a constant or literal in ms sql server?

784