Among available RDBMS. When to use ...

This is a common question on forums. But they just compare the
features. At present RDBMS industry has matured a lot and the big
three have strong competitors too like EnterpriseDB, MySQL etc.

While comparing MS SQL Server, Oracle and DB2, an author writes in a
book:

IBM DB2
--------------
Reliability: Very reliable
Situation: Large to very large databases
Managebility: easy.

Oracle
--------------
Reliability: Very reliable
Situation: Medium to large databases
Managebility: difficult.

SQL Server
--------------
Reliability: low
Situation: small to medium sized databases
Managebility: easy.

Though, the above is the view of that author, I want to know which
RDBMS to use and in what situation, including open source.

If one is working in a company than it is the headache of the
company's project manager or product specialist to make this choice.
But I am running a mISV, so all decisions depend upon me. When you
have plenty of choices, you have to select carefully depending upon
customer's budget, data-size, scalability etc.

For SQL Server, I am not sure, if Microsoft continues to support old
SQL Server formats. Or they , as usual, at a point force to shift to a
new version.

Oracle is unnecessarily complicated and you have to involve a
dedicated DBA. Even, as Oracle claims it suitable for small-to-mid-
sized companies, it's cost and cryptic working is very difficult.

.

Relevant Pages

  • Re: Among available RDBMS. When to use ...
    ... While comparing MS SQL Server, Oracle and DB2, an author writes in a ... Reliability: Very reliable ... Managebility: difficult. ... RDBMS to use and in what situation, ...
    (comp.databases)
  • Re: DTSFTPTask
    ... codputer writes ... >did try to use your control, but it too could not seem to connect. ... existing tasks, mine or MS, when it came to reliability. ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Servers and mySQLs
    ... "Jacky Luk" wrote in message ... > It is very embarrassing ... ... > and SQL Server 2000 in terms of performance, ... > reliability etc can anyone know of a list of ...
    (microsoft.public.vc.language)
  • Re: Monitoring replication from subscriber
    ... have a look on my site for a script to find pending merge changes. ... some discussion about the reliability of the data in it, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)