By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,842 Members | 2,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,842 IT Pros & Developers. It's quick & easy.

SQL 2005 Express vs SQL 2000

P: n/a
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....

Apr 15 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"FreeToGolfAndSki" <wl*@genoagroup.com> wrote in message
news:11**********************@e56g2000cwe.googlegr oups.com...
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....


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.

Apr 15 '06 #2

P: n/a
Greg,

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

Apr 15 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.