MySQL vs SQL server

20 pts.
Tags:
MySQL
SQL
SQL Server
WAMP Stack
If I was going to get some web pages designed to interact with a database on my server would I be better using MySQL or SQL small business server? Is there a huge difference in what they're cabable of or does it just change what front-end you use? Why would I need a WAMP stack and what exactly do they do? I'm totally confused...

Answer Wiki

Thanks. We'll let you know when a new response is added.

Depends on your front end language stack. If you’re going the LAMP route (Linux, Apache, MySQL, PHP), MySQL, in my opinion, has better hooks into that environment than if you’re going with a windows solution.

Personally, it comes down to your skillset (or your developers). MS SQL, by its nature, is a GREAT transactional database that scales very well, but has some underlying performancing that should be done to ensure proper operation. Same goes for MySQL but you can mitigate this somewhat with proper coding, etc.

I’d choose MS SQL if I was using IIS, ASP .NET, etc. I’d choose MySQL if I was using PHP and Tomcat.

hope that helps…

cheers,

Dave

—————————-

Do you have Windows Small Business Server on you server? If not, I think you cannot use that version of SQL server.

What database is better for you? It depends on things like the level of security you want to implement, the amount of data you will need to manage, the performance level you need, budgeting constraints, etc…

This is the conclusion of a comparison article between these MySQL 5 and SQL Server 2005:

“From a database developer’s perspective, choosing between a MySQL and SQL Server DBMS is a matter of the scale of the database application. For enterprise-level applications, SQL Server wins hands down. It has advanced set of SQL features, superior replication, clustering, security and management tools.
For lower-tier database applications, MySQL can offer the core functionality you require at a very low cost. Some might argue that the latest offering from MySQL has made the open source database system enterprise “worthy”, but this remains to be seen. The advanced functionalities implemented are yet to stabilize and be rationalized across the database engine. What’s more, Microsoft has upped the ante with even more advanced features of its own. It’s up to MySQL to rise up to the challenge, but at this point in time MySQL is nowhere near the competitive enterprise field of the more established SQL Server 2005.”

Read the full article here.

LAMPs are packages that allow you to design and serve web pages, and they include a web server (apache), a database management system (MySql) and a programming language (php, or phyton, or perl), running on a Windows OS.

See the WhatIs WAMP page.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    It seems that Dave and me were writing an answer at the same time. I have reverted the answer to the Dave's version, and added mine at the end.
    70,200 pointsBadges:
    report
  • Denny Cherry
    Microsoft SQL Server also has a free version called Microsoft SQL Server Express Edition. Any front end can talk to any database platform equally easily as long as there are database drivers for the database you are using (pretty much every database has drivers for every OS at this point).
    66,290 pointsBadges:
    report
  • DaveGraham
    hey Carlos. ;) Thanks for the append. to MrDenny's point. SQL Express is decent but feature limited depending on scale. I use it for most of my core Virtual Center installations if I'm just using smaller ESX clusters but, outside of that, i'd see very limited use cases. cheers, Dave Graham
    230 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following