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.
LVL 1
IT_LabRatAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
É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:
UnifiedISCommented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.