Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Open source Database vs MS SQL SERVER 2008R2/ 2012

Posted on 2012-03-30
4
Medium Priority
?
1,261 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 800 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

971 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