During a recent Microsoft True-Up piece of work we were doing at work we discovered that 3 of our Microsoft SQL servers had been installed with the Developer edition of Microsoft SQL 2008 R2, this isn’t really an issue because we are licensed for the proper versions but to make life easier for us in the future we decided to upgrade the instances to the correct version now rather than run into this same issue again in the future.
Now there are a couple of ways of doing this but both methods require the installation media and the PID from the target version to hand.
In this guide I will be upgrading from SQL 2008 R2 Standard to Enterprise Edition.
