• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

Sequel Server Express

Has anybody had any problems using the free version of sequel server express in a production environment? I am starting a database application from scratch, and am debating on which database platform to use. Access is available, but not superior. I am thinking about using the free version of Sequel Express, but am weary of any potential problems if/when I need to upgrade to the full version of Sequel.

Open to any thoughts / opinions / experiences.
  • 3
4 Solutions
Aneesh RetnakaranDatabase AdministratorCommented:
You can use it, but there are lots of limitations as it is free
- no sql server agent
-database size is limited
- no sql profiler, no full text indexes
- parallelism is limited
- will perform slower compared to std/ enterprise editions
Éric MoreauSenior .Net ConsultantCommented:
I have a small client running it and they are very happy.

>>- no sql server agent
True. But you can run Maintenance jobs with http://expressmaint.codeplex.com/

>>-database size is limited
True. Limited to 10 GB but you can have more then 1 database on your server.

>>- no sql profiler, no full text indexes, - parallelism is limited
True. True. True.

>>- will perform slower compared to std/ enterprise editions
How? Older versions were throttling after 5 connections but this is no longer the case!
Aneesh RetnakaranDatabase AdministratorCommented:
>> will perform slower compared to std/ enterprise editions
The memory allocation and processor allocation in express edition is different than the other editions, also with no parallelism, it will be slow. (I am not sure this is still applicable for 2012 Express edition )
Aneesh RetnakaranDatabase AdministratorCommented:
Using SQL express will not cause additional problems if you need to move to a full SQL server.  It's definitely a better choice than Access if you have any expectation of going to SQL server.
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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