<p>I am starting a new <strong>client/server</strong> project at work and I want to start using some of the newer technologies I've been reading about, LINQ and Generics being the main ones.  Up until now I have been developing these types of applications with MySQL as clients were unwilling to pay the large licence costs for MSSQL.  </p>

<p>I have played around a small amount with the express versions but have never actually developed anything with them.  The new application will not have more than 5 concurrent connections but will be needed for daily reporting.</p>

<ol>
<li><p>Can MSSQL 2005 express still be downloaded?  I cant seem to find it on the microsoft site. I would be hesitant to use MSSQL 2008 on a project so soon after its release.</p></li>
<li><p>Are the express version adequate for my needs,  I'm sure loads of people reading this have used them.  Did you encounter any problems?</p></li>
</ol>

[{'answer_id': 26850, 'author': 'Mark Biek', 'author_id': 305, 'author_profile': 'https://Stackoverflow.com/users/305', 'pm_score': 1, 'selected': False, 'text': '<p>Note sure about #2 but you can download <a href="http://www.microsoft.com/sql/editions/express/default.mspx" rel="nofollow noreferrer">SQL Server Express 2005 here</a>.</p>\n'}, {'answer_id': 26862, 'author': 'Ian Patrick Hughes', 'author_id': 2213, 'author_profile': 'https://Stackoverflow.com/users/2213', 'pm_score': 4, 'selected': True, 'text': '<p>The answer to the question on any project in regards to what platform/technologies to use is: <strong>What does everyone know best?</strong></p>\n\n<ol>\n<li><p>Yes express <a href="http://www.microsoft.com/express/2005/sql/download/" rel="nofollow noreferrer">can still be downloaded</a>.</p></li>\n<li><p>Will it fit your requirements? That depends on your requirements, of course. I have deployed MSSQL2005 Express on several enterprise level projects which I knew had a fixed database size that would never be exceeded (Express has a limit of each database of 4Gb). Also keep in mind there are other hardware constraints such as a 1 cpu limit.</p></li>\n</ol>\n\n<p>Another thing to consider is if you need the Enterprise level tools that come with a paid edition of SQL Server. If you are moving a lot of flat data around you are stuck writing your own Bulk Copy Procs, which rule the house, but its an extra step, no doubt.</p>\n'}, {'answer_id': 26869, 'author': 'Keith', 'author_id': 905, 'author_profile': 'https://Stackoverflow.com/users/905', 'pm_score': 1, 'selected': False, 'text': "<p>Sql express has more features, and is a lot more powerful, but will only run on windows boxes. If you ever need to scale Sql express can be switched easily to a commercial variant.</p>\n\n<p>MySql doesn't support half the features, but does have most of the basic ones you actually need, and will run on windows or *nix boxes. It's also not throttled in the same way as Sql express is.</p>\n\n<p>In my opinion (having used both extensively, but not touched MySql for a few years) Sql express is a far better DB system. If you're building .Net applications the Linq support is a deal clincher.</p>\n\n<p>If you aren't going for pure Sql server support, I wouldn't go for pure MySql support instead.  Use a DBFactory design pattern to load your data layer or use simple SQL:92 syntax that's a lowest common denominator.</p>\n"}, {'answer_id': 26878, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 1, 'selected': False, 'text': '<p>Why not go to Sql server express 2008?</p>\n'}, {'answer_id': 27170, 'author': 'C Hogg', 'author_id': 634, 'author_profile': 'https://Stackoverflow.com/users/634', 'pm_score': 1, 'selected': False, 'text': "<p>I'm mostly going to advocate MS SQL Server because of .NET integration.  Linq To Sql is pretty much my favorite way to do deal with databases these days:  anonymous functions make everything better!  My current place of work has also used MSSQL Express for real projects, so you have at least two of us confirming that the restrictions aren't too harsh.</p>\n"}, {'answer_id': 38475, 'author': 'vextasy', 'author_id': 3010, 'author_profile': 'https://Stackoverflow.com/users/3010', 'pm_score': 1, 'selected': False, 'text': '<p>I have about 50 web sites running perl/apache/mysql and about 10 running C#/ASP.Net/SQL Server (Lite) and other (large) applications running on SQL Server (Heavy). I never have problems with SQL Server - it just works. I often have problems with MySQL.</p>\n\n<p>My advice would be to go for the SQL Server based option even if you had to pay for it.</p>\n'}]
['https://Stackoverflow.com/questions/26843', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/2720/']