June 11, 2011 at 4:23 am
Hi Team,
What is difference between Migration and Upgradation... please guide me.
Tx
June 11, 2011 at 5:51 am
shiv-356842 (6/11/2011)
Hi Team,What is difference between Migration and Upgradation... please guide me.
Tx
I'm not sure what context you're asking the question, but here's my swipe at an answer.
A migration is moving a database, objects or data between two different servers. An upgrade is when you are changing the version of the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 11, 2011 at 5:52 am
muthukkumaran Kaliyamoorthy (6/11/2011)
ting.kris (6/11/2011)
Spam. Please don't respond.
You don't need to do that. Just click on the Report button and ignore the post otherwise.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 11, 2011 at 6:29 am
thanks grant
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
June 11, 2011 at 9:30 pm
Hi Team,
Thank you for your suggestion
Next time i could not do this type of mistakes
Really i dont know that the reason only i have posted because it is eassy way... to find correct solutions.
i will go to google i will get it, but i think here only i will get
Correct answer ... just because of time saving only i am asking
appologies from my end..
Thanks
June 12, 2011 at 9:33 am
No need to apologize, and we want you to ask questions, but really more pointed questions. The suggestion to Google is for you to try to learn something about it on your own and then ask a question that is more detailed and specific.
June 12, 2011 at 1:04 pm
shiv-356842 (6/11/2011)
Hi Team,Thank you for your suggestion
Next time i could not do this type of mistakes
Really i dont know that the reason only i have posted because it is eassy way... to find correct solutions.
i will go to google i will get it, but i think here only i will get
Correct answer ... just because of time saving only i am asking
appologies from my end..
Thanks
I agree with Steve. No need to apologize for asking on the place where you think you'll get the best answer.
I'll also add to Grant's correct (IMHO) answer...
Not all upgrades require a migration (movement of data and/or code). As Grant pointed out, you may be just be upgrading (no physical movement of data or code) SQL Server or the Operating System.
Not all migrations are for upgrades of SQL Server or the OS. They may be done just because a bigger machine or bigger disk drives are needed. I guess you could call that an "upgrade" because you're moving to better hardware, but I generally don't call those types of things "upgrades". Migrations may also be done without any kind of upgrade at all. It may be just because someone wants the data and related "system" to live on a different box or maybe even at a different location. I had to do that once when our company was bought by another... they wanted to move the data and the code that used it to their central DP center. Nothing was upgraded... well, except that they had better air conditioning and a more physically secure server room than we did. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply