Convert from 2000 database format to 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 28 Mar 2008 12:00 GMT

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

Reply to this Message

John Bell - 28 Mar 2008 12:44 GMT

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/details.aspx?FamilyID=1470e86b-7e05-4322-a677
-95ab44f12d75&displaylang=en
and the upgrade handbook is worth a scan
http://www.microsoft.com/technet/prodtechnol/sql/2005/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_life_it/archive/2006/04/28/477.aspx

John

> 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

Reply to this Message