Upgrade from 7.0 to SQL2K or SQL2K5

Last Post 27 Jan 2006 07:31 AM by RSP_SQL. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
RSP_SQL
New Member
New Member

--
27 Jan 2006 05:38 AM
hi, Forum:

Need ur opinions. I have a client (web provider) that runs its production backend on v7.0. I recommended to upgrade to SQL2K, b/c of the enhancements, developer UDF, XML, etc...
Although they will benefit a lot from SQL2K upgrade, they want to upgrade directly to SQL2K5.....eventually.
Is there any wisdom in going to SQL2K first? What are the pros and cons? What are the primary performance and code considerations when going from 7.0 --> 2000? I recommended that they take this path 70-2000, and then 2005 as its a completely different release. Any thoughts, advice, etc? TIA
RSP_SQL
New Member
New Member

--
27 Jan 2006 07:31 AM
Thx, RM for reply.

I just feel the need for the client to get off 7.0 ASAP, and think that SQL2K can be a quicker, easier win, than SQL2K5 - which I know will push back the upgrade time for at least 6mths to year.

I feel they can benefit from the SQL2K upgrade almost immediately, and that fact that it is most stable, and requires less planning, less environmental changes, and less issues to upgrade to SQL2K, than SQL2K5.



Acceptable Use Policy
---