Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005

Tags:
DTS
SQL Server 2000
SQL Server 2005
SQL Server upgrades
I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any problems with stored procedures, views, etc. The way I was thinking about performing the upgrade is to create a new database on the SQL Server 2005 server with compatibility for SQL Server 2000. Then I'd restore the SQL Server 2000 backup file. Is this a good approach?
ASKED: April 30, 2008  5:51 PM
UPDATED: May 2, 2008  1:49 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

There shouldn’t be any problem with your stored procedures, views, etc.

If needed you can set the compatibility to SQL 2000, but it’s usually not needed.

There is no need to create a new database on the SQL 2005 server and then restore the SQL 2000 database over it. Simply restore the database backup, SQL will create the database for you.

You are correct, DTS will require the legacy tools in order to edit and run the packages.

As always I recommend doing the upgrade is development and QA first, to be sure that there are no problems.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following