StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » SQL Express

SQL Express

Terry Bottorff — Wed, 21 Jan 2009 21:06:16 GMT

I was not sure where to put this question so I put it here. Am I correct that SQL Express is a Single User Environment? (one user working on a table at one time)? My client wants to spend very little on the DB end of the project. What DataBase(s) do users of Strataframe recommend I use? TIA.

RE: SQL Express

Terry Bottorff — Wed, 21 Jan 2009 21:06:16 GMT

Thank you all very very much. The comparison chart was great.

RE: SQL Express

Keith Chisarik — Wed, 21 Jan 2009 19:30:00 GMT

We even use SQL Express with replication to multiple Windows mobile devices simultaneously for one of our products, it has been totally fine.

RE: SQL Express

Trent L. Taylor — Wed, 21 Jan 2009 16:01:34 GMT

We use SQL Server and have many users that use the SQL Server Express version. When they reach the capacity of the SQL Server Express (detailed below) then all they need to do at that point is purchase a full verison of SQL Server and the Express database is literally the very same database, so there is really nothing to do but load a full version.

Here are the Express restrictions:

1 GB of RAM - Only utilizes up to 1 GB or RAM regardless of how much is in the machine
1 CPU - Only processes on a single CPU even if more is available
4 GB database limit - This is generally the one that pushes you over to the full version. But each database within the server can only support up to 4 GB.

RE: SQL Express

Ivan George Borges — Wed, 21 Jan 2009 15:43:50 GMT

And for the second part of your questions, I would tend to say that most of us around here use SQL Server. And depending on your client's requirements, the Express version could do just fine.

RE: SQL Express

Ivan George Borges — Wed, 21 Jan 2009 15:41:45 GMT

Hi Terry.

No, that is not correct. SQL Server Express have some restrictions, but that is not one of them.

For a comparison chart between SQL Server versions, have a look at this link:

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx