Manage Learn to apply best practices and optimize your operations.

SQL Server 2005 upgrade issues

SQL Server 2000 to 2005 migration issues are addressed in detail by expert Adam Machanic.

What possible problems are faced when migrating from SQL Server 2000 to SQL Server 2005? What are all the precautions that should be taken during migration?
There are many issues that you can run into when doing a migration – and it would be far too difficult to explain them all in this space. Luckily, Microsoft has released a tool to help with the transition. You can read all about the upgrading in my article Reduce upgrade unknowns with the SQL Server 2005 Upgrade Advisor.

For more information on migration, I invite you to listen to my webcast Upgrading to SQL Server 2005: What you must know where I share many tips to help ensure a smooth changeover to the new version.

This was last published in June 2006

Dig Deeper on Microsoft SQL Server 2005

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.