Tuesday, February 14, 2012

Convert from 2000 database format to 2005

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.
ThanksHi 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
"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
>

No comments:

Post a Comment