What is difference beteen Migration and Upgrdation?

Answer Posted / pavan

I can say simply.. Migration is the database level..moving the data of db from one server to another or from one environment to another..

Upgradtion is the instance level ..replacing old version with new version. Ex: SQL server 2005 to SQL server 2012.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1305


What is the difference between migration and upgradation in sql server?

608


What is the difference between ddl,dml and dcl commands?

612


What is cte (common table expression)?

601


You want to use a perspective in an mdx query. How do you select the perspective?

157






What do you understand by a view?

559


What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

561


1 01 101 01010

1572


What are pessimistic lock and optimistic lock?

550


Do you know what is lock escalation?

582


Can I save my report as html, excel or word? : sql server management studio

548


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

477


What is a view in sql?

582


How to define the name and server for a new dsn?

549


What is bulkcopy in sql?

562