SQL 6.5 to 2005 upgrade ?? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

SQL 6.5 to 2005 upgrade ??

I have to migrate some databases and some tasks of sql 6.5 to sql 2005. Can I upgrade SQL 6.5 to Sql 2005 directly ? Or Do i have to upgrade to 2000 first and then to 2005? where can i find information on this? I have doubts after reading sticky article of merrialldrich when he could face many issues for just upgrading from 2000 to 2005? Thanks

Check: http://www.microsoft.com/technet/technetmag/issues/2006/01/SmoothUpgrade/default.aspx
Luis Martin
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
SQL Server 2005 Books Online
Copying Databases from SQL Server 6.5 or Earlier
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Refer to the links above and with regard to the sticky post you have mentioned, your application might fall into same issues and may not be provided the queries are optimized and addressed with compatibility issues from 6.5 to 2005 vesion. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.