SQL Server Performance Forum – Threads Archive
What prevents DBAs from migrating to SQL 2005
<br />I read an interesting post on Microsoft.private.mvp.sqlserver from Hilary Cotter, and would like to know views and opinion from all of you.. [You may reply on newsgroup as well]<br /> <br />I was curious as to what is preventing some companies from upgrading to SQL 2005. My list is: -<br /><br />1) Client applications which cannot or have not being re-written to access using the native client provider (Provider=SQLNCLI)<br />2) Client applications which use Extended stored procedures.<br />3) Client applications making using of SQL XML isapi.<br />4) Fear on the part of managements or management which prefers to take a wait and see approach until there is some industry wide opinion on SQL 2005.<br />5) Waiting for service pack 1.<br />6) Our software vendor hasn’t certified their software against SQL 2005 yet.<br />7) We’re worried about how much effort it will take to convert all of our DTS packages.<br /><img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> We can’t live without the Query Analyzer, so we’d prefer to stay on SQL 2000.<br /><br />Deepak Kumar<br /><br />–This posting is provided “AS IS†with NO rights for the sake of knowledge sharing.I haven’t read the thread you’ve mentioned, but I would add: – No current need to migrate since SQL Server 2000 is performing pretty well
– Probably missing obvious advantages of SQL Server 2005 —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
<br />– The post was submitted on "Monday, February 20, 2006 9:47 AM IST"<br /><br /><br />The motto here for the post is to list down all the possible issue that a DBA or an organization face before migrating on SQL2005 and give solutions.<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ /><br /><br />Deepak Kumar<br /><br />–This posting is provided “AS IS†with NO rights for the sake of knowledge sharing.
]]>