Update to SQL 2005 Workgroup Edition

[nevets2001uk]

We currently have SQL Server Standard 2000 with 15 user CALs but will shortly be hosting a company wide database for 110+ users to access.

We will therefore be upgrading to a per processor licensing model for a dual processor DB server and at the same time want to make the upgrade to SQL 2005. We have looked at the Workgroup edition which seems to have enough features to support our company's needs.

Can someone please confirm that you can do an in-place upgrade of SQL 2000 STANDARD to SQL 2005 WORKGROUP?

We only have a few small databases on the server curruntly which we want to upgrade to 2005 with the in-place upgrade.

Steve


Steve G (MCP)

 

[mrdenny]

You can NOT upgrade from SQL 2000 Standard to SQL 2005 Workgroup. When upgrading versions (2000 to 2005) you must go to the equilivant or higher edition (Standard to Standard is fine, Standard to Enterprise is fine, Standard to Workgroup will not work, Enterprise to Standard will not work).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[nevets2001uk]

Ok thanks for the info. I guess we would have to install an instance of 2005 workgroup and then migrate the data from sql 2000? Am I right in thinking this would work?


Steve G (MCP)

 

[mrdenny]

Yes, that will work fine.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[nevets2001uk]

Thanks for your help. Do you know any good resources (Microsoft or others) that describe the best method to properly achieve this migration? I don't really want to reconfigure the clients to point to a different server instance etc.


Steve G (MCP)

 

[mrdenny]

Easiest way is to:
Setup a new machine
Install SQL 2005 Workgroup edition.
Backup all SQL 2000 user databases and restore to SQL 2005 machine.
Change SQL 2000 machine's name and power down.
Change SQL 2005 machine's name to match the SQL 2000 machines name.
Reboot
Tell SQL about the new host name via

exec sp_droplogin 'OldServerName'
go
exec sp_addlogin 'NewServerName', 'local'
go

Restart SQL


Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com