Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL Express vs SQL Server StandardSQL Express vs SQL Server Standard
Previous
 
Next
New Post
3/3/2010 6:41 PM
 

Hello

I have historically always used SQL Server Standard as the basis of my DNN installations, but that's largely because the desktop software my company develops works off a SQL backend with larger DBs (larger than what SQL Express 2005 could handle)

We're looking at a web hosting company to host multiple web sites (up to about 5 per managed host machine) for what would be a largely eCommerce environment, whereby the web host would house the DNN framework files and DNN SQL DB. Due to licensing costs, I'm looking at using SQL Express to house the DNN SQL DB (one instance of SQL Express to hold 5 separate DNN installs) so just wondering what the general feel was out there for SQL Express vs full-blown SQL as far as hosting the DNN DB is concerned

Are there any major limitations of using SQL Express that maybe others have encountered?

The main production database that the web site will chat to (via web services) will still be housed on a full-blown SQL server, so the SQL Express box is purely there to house the web site

Any feedback appreciated

 
New Post
3/3/2010 7:05 PM
 

Adrian, to be honest, I never recommend that anyone try to use SQL Express as a production database. It's great for some sites, minimal use, testing, perhaps even playing with DNN as a developer, but for full blown production websites a full licensed version of SQL is the only thing that I can personally recommend.


Chris Hammond
Former DNN Corp Employee, MVP, Core Team Member, Trustee
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
dnnCHAT.com a chat room for DotNetNuke discussions
 
New Post
3/3/2010 7:47 PM
 

Thanks Chris, will certainly keep that in mind

Might have to get friendlier with our MS buddies, being a partner and all

 
New Post
3/4/2010 3:49 AM
 

Is this just your personal opinion or do you have any facts to back it up? We have used SQL Express on a number of production sites. Can't see anything wrong with that. It just works. If it will work for you, depends on the database size and traffic. Our experience is that SQL Server Express is not the first bottleneck that pops up in a DotNetNuke portal with increasing traffic.

Chris Hammond wrote:

Adrian, to be honest, I never recommend that anyone try to use SQL Express as a production database. It's great for some sites, minimal use, testing, perhaps even playing with DNN as a developer, but for full blown production websites a full licensed version of SQL is the only thing that I can personally recommend.

 
 
New Post
3/4/2010 6:58 AM
 

I have also some good experience with the express version. But in high volume sites the standard is the choice.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...SQL Express vs SQL Server StandardSQL Express vs SQL Server Standard


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out