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!
CI3Asked:
Who is Participating?
 
BrandonGalderisiCommented:
2008 has introduced new features including the more granular datetime2 data type as well as date and time data types.  The ability to pass table variables as parameters into stored procedures was also introduced in 2008.  

Beyond that, the major changes are improvements to the DB engine.

2008/2005 have very similar, if not identical, restrictions on connections and db sizes.
0
 
CI3Author Commented:
BrandonGalderisi,
Thanks, any links you can give that show - 2008 allows unlimited connections?  I can't seem to find any info on that.
0
 
BrandonGalderisiCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.