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

"FreeToGolfAndSki" <wlr@genoagroup.com> wrote in message
news:1145109633.754240.192500@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.

Greg,

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