Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    19

    Arrow Unanswered: SQL7 vs SQL 2000

    I have a choice of which one of these I want to use. Which is more user friendly and more supported?
    Telemarketing right from your PC.
    www.dialeronline.net

  2. #2
    Join Date
    Oct 2002
    Posts
    369

    Re: SQL7 vs SQL 2000

    Originally posted by wooliewillie
    I have a choice of which one of these I want to use. Which is more user friendly and more supported?
    Q1 [Which is more user friendly?]
    A1 They are fairly close in many regards, isqlw 2k is more usable. Depending on your exact needs, 7.0 might be cheaper from a licensing point of view.

    Q2 [Which is more supported?]
    A2 Newer versions (2k) are always supported longer, and generally better.

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    There are significant differences between the 2 - here are the advantages of sql server 2000:

    XML support - (if this is important to you I can go into more detail - let me know)
    indexed views
    object view within query analyzer - (this is a big plus if you use qa)
    new data types within transact sql
    used defined functions
    multiple instance support
    cascading referential integrity constraints for deletes/updates
    ...

    Since yukon is at least 18 months away, starting off with ss2k is your best choice - you won't have to worry about upgrading for a while and when you do the transition between ss2k and yukon will be much less painful than from ss7 to yukon.

    Good luck.

Posting Permissions

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