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

Can we use where clause with group by?

598


Can group functions be used in the order by clause in ms sql server?

680


Explain trigger classes i.e. Instead of and after trigger?

567


How to make a remote connection in a database?

603


What is the correct order of the logical query processing phases?

608






What is difference between inner join and full join?

662


Write a SQL query to make a column as unique?

703


How to write a query with a left outer join in ms sql server?

665


What are two difference between sql azure and azure tables?

147


What is the guest user account in sql server? What login is it mapped to it? : sql server security

674


What is a schema in ms sql server 2005?

645


do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

570


What does it mean to invest in the index?

606


What does it mean to manipulate data?

661


How do you troubleshoot errors in a SQL Server Agent Job?

645