Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Location
    Illinois ~ USA
    Posts
    1

    Question Unanswered: Benefits of upgrading SQL 7 to 2K

    Could someone please let me know the specific 'benefits' of upgrading a SQL 7 system to a 2K? For instance if any of you have done this, did you notice a significant change within your system(s)?


    Thanks!!!

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Well, as an Enterprise solution, 7.0 cannot be reliably clustered. Performance may improve on certain queries, but don't be surprised to see a degradation, though it's pretty rare. The most benefits are for applications that are either being newly developed or the ones that can be modified without infringing your support agreement with your vendor. The reason is added functionality. But if your system needs only backups and occasional reindexing, - don't fix what ain't broke

  3. #3
    Join Date
    Aug 2003
    Location
    Boston, MA
    Posts
    7
    There are lots of benefits to upgrading and many articles available on the subject...

    Here are a few links that will give you some background:

    http://msdn.microsoft.com/library/de...entid=28000409

    http://msdn.microsoft.com/library/de...asp?frame=true

    CPN

  4. #4
    Join Date
    Aug 2003
    Location
    SW Ohio
    Posts
    198

    Re: Benefits of upgrading SQL 7 to 2K

    Originally posted by NotAvg1
    Could someone please let me know the specific 'benefits' of upgrading a SQL 7 system to a 2K? For instance if any of you have done this, did you notice a significant change within your system(s)?

    Thanks!!!
    There are a few keywords, functions, etc. that are in 2K that aren't in 7. We have one vendors application that uses some of them, but they are good enough to have an MSDE version that we can use.

    I would say that unless you are worried about clustering, or a specific application requires it, I don't think there is enough justification.

    Besides I bet a 2K3 or 2K4 version is probably in alpha testing somewhere. That way you could just jump versions.
    Jim P.

    Supoorting Oracle, MSSQL7, Sybase 8, & Pervasive. Confusion Reigns

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •