Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 upgrading workgroup edition to standard

Author  Topic 

icw
Constraint Violating Yak Guru

378 Posts

Posted - 2010-07-12 : 13:03:38
Is there a way to upgrade SQL 2005 workgroup edition to Standard edition? if so please tell me how.
Our software provider told us there is no upgrade path , he said you have to upgrade to 2008 first. Surely this can't be right?
My reason for wanting to do this is...I have created lots of SSIS packages for a SQL server on my dev machine and when I have tried to apply them I realised that the production server is workgroup edition which doesn't have the ability to create data transformation packages.
Thanks

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-07-12 : 13:10:17
There's some information here on how to do an in-place upgrade:

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/3b5a8e41-0ea8-40e5-afc8-e8c38afc82d4

Be sure to read everything carefully before you start. I'd suggest testing it on a different server beforehand. You'll have to add SSIS components after the upgrade step.

SQL Server 2008 has a GUI option to upgrade editions, which is probably why your provider said what he/she did.
Go to Top of Page
   

- Advertisement -