February 20, 2010 at 12:51 am
Hi,
What is the technical reason why i cannot upgrade sql 2000 enterprise edition to sql 2005 Standard Edition evethough am using the common features in both the editions. Y is it so? any architectural changes or any low level coding ????
Thanks!
February 20, 2010 at 10:43 am
The technical reason is that it's not support. http://msdn.microsoft.com/en-us/library/ms143393%28SQL.90%29.aspx I don't believe setup will allow this.
Can you do it if you handle the uninstall/reinstall, attach dbs, move jobs/logins/packages with scripts? Yes.
No reason not to, it's just a manual process. Not hard, lots of moving parts though.
February 22, 2010 at 2:58 am
Yes, Inplace upgrade is not possible in your scenario.
But you can go with side by side upgrade or as mentioned by Steve do unistall/reinstall...
In side by side upgrade you will have both SQL Server 2000 and 2005 available on the same box.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
February 23, 2010 at 3:33 am
As people have said, Microsoft decided this type of in-place migration would not be supported.
Most people upgrading from SQL 2000 to SQL 2005 or SQL 2008 recommend you do a side by side upgrade. There is a risk that an in-place upgrade will fail leaving SQL Server in a state where it cannot be started. The only way out of this is to uninstall SQL Server, then reinstall SQL 2000 and do a side by side upgrade.
If you do decide to do an in-place upgrade your planning should include what you intend to do if the in-place upgrade fails. IMHO the fact you need to plan and test how you would do a side by side upgrade means you may as well take the low risk approach and do all the upgrades as side by side.
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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply