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
Solved

Open source Database vs MS SQL SERVER 2008R2/ 2012

Posted on 2012-03-30
4
1,229 Views
Last Modified: 2012-07-16
Which Open Source database is good for building enterprise application?
What are their pros and cons ?
What benefit is choosing propriety database (ms sql server) over open source and vice verse.

Open Source Database
1. Postgre Sql
2. MySQL
3. Firebird
list is long.

Propriety
1. SQL SERVER 2012/2008R2
0
Comment
Question by:gopalchettri
4 Comments
 
LVL 9

Accepted Solution

by:
OCDan earned 200 total points
ID: 37788387
There are many reasons to choose either Open or Closed source. The main one being cost. However, if the database is relatively small SQL Server Express may be a good idea as it is free. See the comparison here

Another factor (although reduced lately) is what you plan to use the SQL Server for, if you want to build .NET applications using the DB then SQL Server makes sense as they are both Microsoft. Although you can use other databases if needed.

Personally I find SSMS (SQL Server Management Studio) perfect for working with the database and the MySQL equivalent is nowhere near as good IMO.

The last reason I would pick SQL Server over the overs is that it is generally easier to get help on any problems as it is more widely used than the open-source applications, and is also generally better documented.

Ultimately though the languages are very similar so you can chop and change from that side of things once you know one, however, the further down the road of implementation you get the more difficult it becomes.

Just my 2 cents but I hope it helps.
0
 
LVL 2

Author Comment

by:gopalchettri
ID: 37860829
How about Firebird and Postgre sql.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

809 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