Click here to Skip to main content
15,740,731 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I did a project where I used Sql server 2000 as database ,but now I use SQL server 2005 .So I need to convert the database backup..But I cann't do so....So how I can convert this
DaveAuld 28-Sep-10 18:46pm    
Why can't you do so? does it give you an error? did you follow the migration path instructions (if there are any)?
DaveAuld 28-Sep-10 18:49pm    
Just did a search on Google for: SQL2000 to SQL2005 ;and it comes up with a few guides to follow, depending on what exactly you are trying to do.
kibria06cse 28-Sep-10 19:11pm    
No I don't find any kind of migration there and it also gives an error about database

1 solution

You dont need to anything to migrate database from SQL2000 to SQL2005. Just backup the database in SQL2000 and restore the backup file in your SQL2005 server. Server will itself change your version of your database. If you are getting any specific error then that might be some other issue. You can post the error message so that someone can help you regarding that error.
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900