At the moment, I have a SQL 2005 Standard box. I'd like to upgrade it to SQL 2012 Enterprise in-place. When I say in place, I mean an install similar to Office 2010, e.g. it removes the older (Office 2007) version, binds itself to extensions once held by its predecessor and keeps all the settings as well.
Is this possible?
If not, what should be the procedure? So far, I got this.
- Back up the databases
- Write down all the settings.
- Uninstall SQL 2005.
- Install SQL 2012 Enterprise.
- Restore settings
- Restore the databases.
Best Answer
Yes, according to Supported Version and Edition Upgrades you can upgrade in place from 2005 Standard to 2012 Enterprise, provided SQL Server 2005 is currently on an operating system supported by SQL Server 2012 Enterprise (meaning forget about XP or 2003 RTM) and that the architecture is the same (e.g. 64-bit -> 64-bit).
Though you should do step 1 and 2 anyway so you have something to compare to and fall back on, since you never know what might go wrong during the upgrade. (And don't forget to knock on wood and all that.)
Personally I prefer a side-by-side installation onto a new machine, especially if the 2005 hardware and/or operating system is old. The performance benefits you get "for free" when you upgrade are amplified immensely when you also upgrade the underlying stuff as part of the process.