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

Which language rdl files made of?

114


What are triggers in ms sql server?

795


What are the restrictions while creating batches in sql server?

757


What is the fillfactor concept in indexes?

721


Name few endpoints exposed by ssrs 2012?

330






Where is trigger in sql server?

722


Which are the third-party tools used in sql server and why would you use them?

659


Explain the cursor lock types?

739


What is user defined stored procedures?

715


What is @@rowcount in sql?

729


Why do we need normalization?

661


What are the purposes of floor and sign functions?

729


How do you rebuild an identity column?

716


Which are new data types introduced in sql server 2008?

808


How to create an inline table-valued function?

715