I took some time to choose a right title for this blog post. Over the years I have seen people using these terms, “Upgrade” & “Migration” interchangeably. Yes, I know, many of you would think that it is so ‘simple’ as these two have distinct meanings but I am sure, there are other lots that would agree, that it is indeed a little ‘confusing’ or sometimes mean the same thing. There goes my title – “Upgrade vs Migration – simple yet confusing” :).
So, let me explain Upgrade vs Migration in simple words.
‘Upgrade’ simply means upgrading the old version of a product to a new version. So suppose you want to move from SQL Server 2005 to 2008; we would call it an upgrade. We would say: “Upgrading” from SQL Server 2005 to SQL Server 2008.
Many of you would know, we have 2 options here: In-place upgrade and side-by-side upgrade. Now suppose, you want to do a side-by-side upgrade and you set up a new system and perform a SQL Server 2008 installation. You have to now move your data to this new system – and this is what we call as migration – “migrating” data from the old system to a new system. However, the next step or the overall thing is still an upgrade.
We also use the term migration, obviously, when we migrate from Oracle to SQL Server or vice versa, though I prefer the former one 🙂