2

I'm moving my ASP.NET website to a new provider. Only problem is, old host support my SQL Server 2000 db. New host only supports SQL Server 2005. How should I go about the conversion ? Can I simply produce a backup of the 2000 (.bak) file at the old host, and restore that file into SQL Server 2005 at the new host ? Or is there more to it ??

Note that I don't own a copy of SQL Server 2005 at home... and I'm trying to avoid having to do so.

Thanks, Bazza

Improve this question
1
  • 1
    You can download SQL Server 2005 Express which is free. Commented Apr 14, 2010 at 6:01

3 Answers 3

Reset to default
2

Simple restoring of backup is enough. It workes fine for me.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I've never had a problem restoring 2000 backups onto 2005 either.
1

Generate Deployment scripts using "Database Publishing Wizard" for your Sql200 database and select target dataabse type as "sql2005". It should work flawlessly as we have experienced the same in past.

Improve this answer

5 Comments

Hi thanks for quick response.. Is the "Database Publishing Wizard" part of the SQL Server Enterprise Manager for 2000 ? I couldn't see that wizard anywhere ?? Thanks
Sorry.. just saw the link... i've downloaded the publisher. thanks again.
Just tried that.. it seems to have worked really well. thanks again!
I don't seem to get a vote ?? Too new as a user on this site perhaps ?
you will find a check-mark option below the vote-count of my answer. You shall click on it to mark my answer as accepted answer by you. This will help others to easily find the right workable solution for the query he might have similar to your question - and of course it will gain me some reputation on SO.
0

Do you use Data Transformation Services (DTS)? This SQL Server 2000 feature can't be migrated right away into SQL Server 2005. You'll have to migrate your DTS-packages to SQL Server Integration Services.

Running the SQL Server 2005 Upgrade Advisor helps identifying this issue.

Improve this answer

1 Comment

Not strictly true. The "backward compatibility" components can be installed to allow SQL 2005 to run DTS packages.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.