CI3
asked on
Difference: SQL Server 2005 Express vs SQL Server 2008 Express
We have an app that we were planning on sending out with a copy of SQL Server 2005 Express. However since the 2008 version is out I am just wondering if there is a reason to not use it.
One of my biggest concerns is what has changed in the 2008 version. I can find an abundance of information on the 2005 Express restrictions and such but not finding a lot on the 2008 version. Aside from basic OS and PC requirements.
So I guess Im looking for 3 things mainly:
1) Whats the difference between the 2005 and 2008 Express versions?
2) Which would be recommended to use?
3) I know 2005 version has no connection restrictions but I can't seem to find that info anywhere on the 2008 version. What are its restrictions? Our app needs no connection restrictions since multiple connections will be required.
I'm no SQL expert by any means so assume I need the extra details in any explanation.
Thanks!
One of my biggest concerns is what has changed in the 2008 version. I can find an abundance of information on the 2005 Express restrictions and such but not finding a lot on the 2008 version. Aside from basic OS and PC requirements.
So I guess Im looking for 3 things mainly:
1) Whats the difference between the 2005 and 2008 Express versions?
2) Which would be recommended to use?
3) I know 2005 version has no connection restrictions but I can't seem to find that info anywhere on the 2008 version. What are its restrictions? Our app needs no connection restrictions since multiple connections will be required.
I'm no SQL expert by any means so assume I need the extra details in any explanation.
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This page compares the editions.
http://msdn.microsoft.com/en-us/library/cc645993.aspx
There is no mention about unlimited connections. And it's not UNLIMITED. It's limited by system resources on the host.
http://msdn.microsoft.com/en-us/library/cc645993.aspx
There is no mention about unlimited connections. And it's not UNLIMITED. It's limited by system resources on the host.
ASKER
Thanks, any links you can give that show - 2008 allows unlimited connections? I can't seem to find any info on that.