Upgrade SQL 2000 EE to SQL 2005 SE

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)

Upgrade SQL 2000 EE to SQL 2005 SE

Author

Topic

hey001us
Posting Yak Master

185 Posts

Posted - 2009-01-05 : 16:11:21

As per my understanding, SQL is not supporting to Upgrade from SQL 2000 EE to SQL 2005 SE.
Is there any other best way to upgrade Enterprise Edition
to Standard Edition on In-Place or any other method? Its is my Test sever.

Thanx

hey

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2009-01-05 : 23:41:58

Check this: http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

You can install the 2005 server as a side-by-side install and transfer all your objects from 2000 server to 2005 server.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

ghemant
Starting Member

22 Posts

Posted - 2009-01-06 : 07:18:29

Yes, I second Dinakar's suggestion. Side-By-Side installation is good and recommended option against In-Place method.

Regards
Hemantgiri S. Goswami
http://hemantgirisgoswami.blogspot.com/

hey001us
Posting Yak Master

185 Posts

Posted - 2009-01-06 : 16:26:56

Thanks for your suggestion.

hey

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources