Re: MS SQL Server vs Oracle, MySQL or MongoDB

  • From: Matthew Zito <matt@xxxxxxxxxxxxxxxxx>
  • To: ksmadduri@xxxxxxxxx
  • Date: Wed, 27 Aug 2014 13:25:57 -0400

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@xxxxxxxxx> 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
>

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2014