SQL 2005 Express vs SQL 2000

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • FreeToGolfAndSki
    #1

    SQL 2005 Express vs SQL 2000

    I'm thinking of migrating our 12 user SQL 2000 db to SQL 2005 Express.
    The db is about 2 gb. Does anyone know if there is a no of users or db
    size or other restrictions on SQL 2005 Express. How about performance
    relative to SQL 2000? Thanks in advance....

    Tags: None
    • Greg D. Moore \(Strider\)
      #2
      Re: SQL 2005 Express vs SQL 2000


      "FreeToGolfAndS ki" <wlr@genoagroup .com> wrote in message
      news:1145109633 .754240.192500@ e56g2000cwe.goo glegroups.com.. .[color=blue]
      > I'm thinking of migrating our 12 user SQL 2000 db to SQL 2005 Express.
      > The db is about 2 gb. Does anyone know if there is a no of users or db
      > size or other restrictions on SQL 2005 Express. How about performance
      > relative to SQL 2000? Thanks in advance....
      >[/color]

      SQL 2005 Express is limited to 1GB of RAM, a single CPU and a 4GB database.

      That's about it. It does NOT have the query governor that the MSDE had.

      In general if it's a small database, you should be fine and may even see an
      increase in performance.



        Comment

        • FreeToGolfAndSki
          #3
          Re: SQL 2005 Express vs SQL 2000

          Greg,

          Thanks for the help. We have about 10 users and 25 cals for SQL Server
          2000. What about user issues?

            Comment

            Previous template Next
            Working...