February 7, 2008 at 1:12 am
We are currently running a couple of SQL Server 2000 servers (Enterprise edition). Because MS is ending support for SQL 2000, we have to upgrade to SQL 2005. After evaluation our requirements, I believe the Standard edition of 2005 will be more than adequate for our needs. Although we're not using any of the Enterprise edition features, I'm not sure if I can upgrade to SQL 2005 Standard. The MS web site says it's not supported, but I wondered if anyone out there has tried it?
February 7, 2008 at 11:51 pm
As per the below link, you can perform an Inplace Upgrade from SQL Server 2000 EE SP3 or later to SQL Server 2005 EE. In your case it is not possible to perform the same as you cannot do an Inplace upgrade to Std edition of Sql 2005.
http://msdn2.microsoft.com/en-us/library/ms143393.aspx
However you can do an Side by Side upgrade from Sql Server 2000 EE to Sql 2005 Std as shown in the below link,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2477578&SiteID=1
Also I would recommend you to read this Upgrade document from MS,
[font="Verdana"]- Deepak[/font]
February 8, 2008 at 2:47 am
Most people who have been through the migration process recommend you do not do an in-place upgrade. It is far safer to uninstall SQL Server 2000 and do a clean install of SQL Server 2005.
I have done in-place upgrades that worked OK. I have also done in-place upgrades on seemingly identical servers that failed part-way through leaving SQL Server completely dead - the only way out was an uninstall followed by a clean install. If you do proceed with an in-place upgrade, you need to plan for this contingency. I have never done an in-place upgrade on a Production box and intend to keep it that way.
You may find http://www.codeplex.com/SQLServerFineBuild helpful. I published this to help provide a 1-click install and configuration of SQL Server 2005. It also includes advice and some tools to help in upgrading from SQL Server 2000.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply