CODEWITHSUNDEEP
sql-serversql-server-express
Craig Day
Craig Day

Reputation: 2535

Are Microsoft SQL Server "Express" editions free to develop on?

Am I able to develop a software for free on Microsoft SQL Server 2005/2008 Express edition databases?

Upvotes: 6

Views: 917

Answers (4)

MicTech
MicTech

Reputation: 45023

Yes, You can.

But Express version have few limitations

  1. SQL Server use only one CPU at a time
  2. Maximum memory is 1GB
  3. Database size limit is 4GB

And you can redistribute SQL Server, but you must register for that at Microsoft.

UPDATE - SQL Server 2008 R2

Database size limit is 10GB

Upvotes: 11

mnuzzo
mnuzzo

Reputation: 3577

Wrong Answer: As far as I know, you are free to develop in any Microsoft Express Edition as long as you do not redistribute the code commercially.

EDIT: I swear I read a license a while ago which said you couldn't. They must have changed it on me, either that or I'm thinking of the license for my student edition. Sorry about that.

Another Edit: Just clarifying, my original answer was completely wrong, I got my MS licenses confused. As far as I know from reading the licenses last night, you can develop to your hearts content with Microsoft Express Edition software.

Upvotes: 1

marc_s
marc_s

Reputation: 754478

Yes, SQL Server Express is free to develop on, free to use, free to ship to your customers - FREE all around! :-)

In addition to MicTech's list of limitations, SQL Server Express is (at this time) 32-bit only.

As for the 4 GB limitation for the database, this is per database, so you can easily have several databases in SQL Server Express on the same machine - each up to 4 GB in size. And in SQL Server Express 2008, the data stored in the FILESTREAM filegroup (BLOBs stored on disk) is not considered for this limit.

Marc

Upvotes: 3

John Weldon
John Weldon

Reputation: 40759

Yes, here is a relevant faq.

You are free to redistribute your applications commercially...

Upvotes: 6

Related Questions