Open source Database vs MS SQL SERVER 2008R2/ 2012

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
LVL 2
gopalchettriAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
OCDanConnect With a Mentor Commented:
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
 
gopalchettriAuthor Commented:
How about Firebird and Postgre sql.
0
All Courses

From novice to tech pro — start learning today.