Q
Problem solve Get help with specific problems with your technologies, process and projects.

Moving from SQL Server 7.0 to SQL Server 2005

Skipping right over SQL Server 2000? Get insights from SQL Server 2005 expert Adam Machanic on making this move.

I am thinking about converting from SQL Server 7.0 to SQL Server 2005. Is there anything specific I should be aware about regarding this conversion? I know we are behind the curve on this, but I may have the choice of going to SQL Server 2000 or SQL Server 2005. I'd rather upgrade to SQL Server 2005 than be stuck with an outdated version again. Any thoughts?
I'm glad to hear that you're getting ready to catch up! The conversion itself should not be especially difficult. As mentioned in my webcast, the simplest options are probably in-place upgrade or backup and restore. Both of these methods are simple to implement, and I don't think there's much more you should know. The most important thing you can do is test everything thoroughly. Test the upgrade in a development environment, and test everything in production as soon as your upgrade is complete. You can never over-prepare for a major upgrade like this.
This was last published in December 2005

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.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close