Re: MS SQL Server vs Oracle, MySQL or MongoDB
Date: Wed, 27 Aug 2014 13:25:57 -0400
Message-ID: <CAJ7936ySF5Uyeqg9vdgNb5XPLxAUAPv9T5MgJOS+nrE6Z67FjQ_at_mail.gmail.com>
This is a big question, with a lot of loaded implications, so I'll try to be matter-of-fact about it. People choose SQL Server for all kinds of reasons, many of which are debatable as far as their being fact vs. opinion:
- "SQL Server is cheaper than Oracle, but more reliable than MySQL"
- "It's easier/cheaper to hire SQL Server DBAs than it is to hire Oracle or MySQL DBAs"
- "I like having a GUI, adn the SQL Server GUI is a lot easier to use than the Oracle EM GUI"
- "We're microsoft partners"
- "We're more comfortable in Windows than we are in Linux/UNIX"
- "We acquired a company with a big SQL Server presence"
- "We buy a lot of COTS software that supports SQL Server"
and so on. It's rarely just a cost factor.
Note also that while MongoDB is cool and has a variety of things to recommend it (as well as a bunch of other alternative datastores), Mongo is not really a comparable replacement to SQL or Oracle or MySQL or any RDBMS basically.
Thanks,
Matt
On Wed, Aug 27, 2014 at 1:17 PM, Kumar Madduri <ksmadduri_at_gmail.com> wrote:
> Hello
> I have just started to understand and learn MS SQL Server 2012 and from
> what I understood so far
> Why would anyone want to implement MS SQL Server ?
> If cost is one reason, then there are options like MySQL or MongoDB which
> would be less expensive than Oracle and can be used on multiple platforms.
> If application vendor restricts to use MS SQL server then that is the only
> reason I find to use MS SQL Server.
> The other reason is probably the shop does not have unix sysadmins and are
> comfortable with windows (windows shop).
> Are there any other reasons why somebody would choose MS SQL server?
>
> Thank you
> Kumar
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 27 2014 - 19:25:57 CEST