I have a SQL 2000 database that is almost 3 gig's. Small by some
people's standards. I would like to convert the Database to a 2005
format. Is there a conversion wizard, or a process that will do
this? Please advise with as much instruction as possible.

Thanks

Hi Dave

Look at the SQL 2005 Upgrade Advisor to see what you may need to change when
upgrading the database
http://www.microsoft.com/downloads/d...displaylang=en
and the upgrade handbook is worth a scan
http://www.microsoft.com/technet/pro.../sqlupgrd.mspx.

It will also be advisable to rebuilt indexes, update statistics and usageage
you may also want to check out
http://rentacoder.com/CS/blogs/real_...04/28/477.aspx

John

"Dave" wrote:

> I have a SQL 2000 database that is almost 3 gig's. Small by some
> people's standards. I would like to convert the Database to a 2005
> format. Is there a conversion wizard, or a process that will do
> this? Please advise with as much instruction as possible.
>
> Thanks
>