Solved

Open source Database vs MS SQL SERVER 2008R2/ 2012

Posted on 2012-03-30
4
1,232 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
[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
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

739 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