I have a Windows 2003 Server with SQL Server 2008 Enterprise Evaluation edition installed. The evaluation is due to expire this week so we need to upgrade to our recently procured licensed copy of SQL Server 2008 Enterprise Edition (Microsoft Volume License).
MS Would have you believe that it is possible to simply upgrade. http://msdn.microsoft.com/en-us/library/ms143393.aspx
However in testing, at the point when the upgrade tries to verify the features to be upgraded in the pre-installation section of the upgrade, an error is produced advising there is nothing to upgrade and there appears to be nothing to select for upgrade.
Ideally I would rather perform an uninstall / reinstall of SQL and restore or re-attach the original DB's. However, I am unsure whether simply restoring all of the original db's will actually restore everything that is required for the system to work. I would appreciate any advise on exactly what is required in terms of migrating data when uninstalling and reinstalling SQL Server 2008.