any suggestion?

[habesha]

Can any body suggest easy way to upgrade from sql server 2000 to sql server 2005

Thanks

 

[ptheriault]

There are a few ways you can upgrade your current SQL2000 install to 2005. In my opinion I've found the best method is a clean install to a new server and use the detach method to move the databases. That gives you the ability to test without impacting current production. I'll admint that method is not always possible if you can't purchase new hardware. Here is a link that goes through the ways you can upgrade.

http://msdn2.microsoft.com/en-us/library/ms144267.aspx

- Paul
- If at first you don't succeed, find out if the loser gets anything.