?
Solved

Best Back End Database Solution

Posted on 2006-12-01
6
Medium Priority
?
206 Views
Last Modified: 2010-04-23
Hi. I am looking for some advice in terms of the best and most cost effective back end database for a commercial vb 2005 winforms application. The application will reside on the clients windows server and have a maximum of 20 users/connections. I am currently considering things like MySQL or SQL Server Express Edition. Initally the number of transactions and table records will be relatively low however this will grow over time. Can any advice also please detail licensing requirements and est. costs.
0
Comment
Question by:staritsj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
6 Comments
 
LVL 13

Accepted Solution

by:
newyuppie earned 672 total points
ID: 18058014
MySQL is free. well, there are some limitations, i think the only issue is that you must deploy your source code as well if you plan to use the free edition. i dont know about SQL Express. ç

if you pay for it, MySQL i think ranges from 600 to 5000 per year per server (https://shop.mysql.com/enterprise/). while SQL SErver ranges from 4000 to 25000 (http://www.microsoft.com/sql/howtobuy/default.mspx)

MySQL is compatible with a lot of systems, while SQL Server only with Windows.

hope it helps
NY
0
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 18058123
SQL Express is FREE.  It's MSSQL compatible, and should handle 20 user connections fine.  It has a database size limit of 4 GB, If I'm not mistaken (AT LEAST 2 GB).  So provided the database stays relatively small, it's more than sufficient for these purposes.  If the database/user base grows, you can just upgrade to MSSQL.  In smaller environments, your clients can use SBS to gget full SQL server support at a reasonable price.
0
 
LVL 24

Assisted Solution

by:Jeff Certain
Jeff Certain earned 664 total points
ID: 18059772
There are also some issues using SQL Express as the parent (or master) for replication.

The SQL Server cost quoted above is a one-time cost, not annual... at least that's been my experience.
0
 
LVL 96

Assisted Solution

by:Lee W, MVP
Lee W, MVP earned 664 total points
ID: 18060550
I wouldn't believe the SQL prices quoted above.  SQL pricing really varies based on the version and number of processors you buy.  Further, the processor licenses don't count cores as processors.  So you could by a single processor license but use a quad core chip to effectively have 4 CPUs on the system with a one processor license - potentially great performance.  The prices quoted look to my like Enterprise pricing.  Workgroup and Standard editions of SQL could be just as good/appropriate for your application and cost much less.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

This article explains how to create and use a custom WaterMark textbox class.  The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.   IMAGE OF WATERMARKS STEPS Create VB …
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

649 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