Converison process from sqlserver2000 to 2005

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

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

Posted 28-Sep-10 11:44am

kibria06cse

Add a Solution

Comments

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Goutam Patra · Accepted Answer · 2010-09-28T21:49:00

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.