SQL Server Performance

What prevents DBAs from migrating to SQL 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by deepakontheweb, Feb 19, 2006.

  1. deepakontheweb New Member

    <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.
  2. FrankKalis Moderator

    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
  3. deepakontheweb New Member

    <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.

Share This Page