I'm in the position where I've run into the limitations of SQL server express and have bought a license for SQL Server Web edition. What is currently installed on the server is SQL Server 2008 Express with Advanced Services, and I'm trying to upgrade it to SQL Server 2008 R2 Web Edition. I've since discovered that you can't upgrade any edition, including express, to Web Edition. So here I am with ~100 databases that I somehow need to get upgraded.
The only option I can think of is slow and painful, and consists of
- Installing Web Edition side-by-side on the server
- For each db, take the site & database down, copy the database to web edition, update the connection strings for my site, and bring everything back up
The only other possibility I came up with was:
- Install Web Edition to new named instance
- Take all the current sites and databases down
- Move the databases to Web edition
- Take down or rename the express named instance
- Rename the web edition named instance to the old express named instance
EDIT - It appears it's not really possible to rename a named instance
Both of these are way more complicated than I was hoping for, option 1 will take a long time and result in a lot of manual interaction, and option 2 will result in a lot of downtime.
Is there any GOOD way to do this? I've found almost nothing about people upgrading to web edition.
PS. Anyone know why the hell you can't upgrade to web edition?