[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 733
  • Last Modified:

SQL Express vs SQL Server

What are the practical differences between SQL Express and SQL Server. What is the limit of concurrent users in Express? And is there anything that would run in Server that won't run in Express. I'm not referring to size of db or ram but feature wise.

0
curious77
Asked:
curious77
1 Solution
 
BrandonGalderisiCommented:
Here's the list of features between editions:

http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx
0
 
k_rasuriCommented:
Database wise you will be able to manage but you wont get any BI tools like SSIS, SSAS, SSRS.
0
 
rpkhareCommented:
SQL Express Edition is FREE fully-functional edition. It has a 4GB data limit and supports 1 server. You may not find enterprise features of SQL Server in it like Failover, clustering etc, but it is more than sufficient for small to mid-sized applications.
0
 
curious77Author Commented:
rpkhare:
Is there a limit to the number of Users that can be logged in at once?
0
 
rpkhareCommented:
I don't think there is any limit to the number of users. However, go through these articles:

http://www.vsj.co.uk/articles/display.asp?id=442
http://www.sqlmag.com/Article/ArticleID/47721/sql_server_47721.html

I would recommend to go for SQL Server 2008 Express Edition with Advanced Services. You will get some more features.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now