First published on TechNet on Mar 18, 2008
As more and more people are installing SQL 2005 WE, we wanted to refresh and clarify a few points and concerns. These are most likely addressed here and there, scattered around the Internet, so hopefully we can provide a quick way of getting to all of them.
The first thing we want to address is the lack of in-place upgrades from SQL 2000 Standard to SQL 2005 Workgroup Edition, if you need an instance to be SQL 2005 WE, you will need to migrate it. This is a limitation of SQL 2005 WE.
In order to migrate your instances, you will need to consult the line of business vendor for proper migration steps (and to confirm support for SQL 2005 WE). From a technical perspective the steps are pretty straightforward, but there are always gotchas. Make sure you test the migration in your test environment before deploying in production.
High Level Overview of Migration Process:
Backup the databases
Record any logins under security and other relevant configurations
Uninstall the instance you want to migrate to SQL 2005 WE
Address the issues described in the following 2 KB articles: