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
, 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.
Dig Deeper on Microsoft SQL Server 2005
Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ...
Migrating to SQL Server 2005 from SQL Server 2000 is a hefty feat when compared to upgrading from 7.0 to SQL Server 2000. Site expert Adam Machanic ...
SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert...