Posted by jlaustill@gmail.com on 06/21/07 13:26

On Jun 21, 5:53 am, Oonz <arund...@gmail.com> wrote:
> Hi Friends,
> Is there any tool or assistant to upgrade SQL 2000 to SQL 2005.
>
> Thanks,
> Arunkumar

Hey Arunkumar,

You don't really need a special tool for this task. You just need to
either make a backup of your database and restore it on the sql 2005
box, or do a dts database transfer. Depending on the size of the
database doing the backup route is generally the easier path. If you
need it to be on the same machine, you can take backups of all your
databases, uninstall sql 2000, install 2005, then just restore all the
databases. You will have a few minor problems to work out, such as
orphaned users, which can be a real pain if you have thousands of
them(been there myself). But for the most part everything will work
just fine.

I would recommend that if you've never done it before that you try it
on a test box before you attempt it live, especially if your data is
important at all :) Have a good go of it man.

Joshua

[Back to original message]