Solved

Open source Database vs MS SQL SERVER 2008R2/ 2012

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

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…
Creating and Managing Databases with phpMyAdmin in cPanel.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now