Solved

Sequel Server Express

Posted on 2013-01-21
5
369 Views
Last Modified: 2013-01-21
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.
0
Comment
Question by:IT_LabRat
  • 3
5 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 125 total points
ID: 38802164
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
0
 
LVL 69

Assisted Solution

by:Éric Moreau
Éric Moreau earned 62 total points
ID: 38802191
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!
0
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 125 total points
ID: 38802221
>> 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 )
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 38802272
0
 
LVL 18

Assisted Solution

by:UnifiedIS
UnifiedIS earned 63 total points
ID: 38802341
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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now