Re: Oracle vs. Sybase

As SQL Server is a direct derivative of Sybase, you'd expect this to be a simple answer. However, when MS took over the code base, they ensured that people would be captured to the SQL Server variant by putting in significant added value. As a result, your question now expands to additional questions:

• difficulty in obtaining support?
• difficulty in finding qualified people?
• availability of courses and other resources?

Oracle does provide migration utilties from SQL Server and Oracle is supposedly written first on SOlaris, so there is very good support on that platform. In addition, Oracle is pervasive on all major platforms, so the investment does not stop future migration to other OS.

I personally like Oracle - but to be fair, I can not knock Sybase as I don't have current experience.

/Hans

Alexej wrote:

> Hi,
>
> currently, we are running NT 4 and SQL 6.5 and 7, but we plan to migrate to
> a UNIX platform. So far, our platform choice #1 is UltraSPARC + Solaris.
> Now, we have to decide, what DB we should use. It seems, that the most
> frequently used commercial databases (on Unix) are Oracle (8i) and
> Sybase.(ASE 11.x/12.x)
>
> here are my questions:
>
> What are the (general) differences between the both?
> What would you recommend? Which would be the "easier" choice (easier to
> migrate from MS SQL Server)?
>
> As far, as I understand, Sybase uses T-SQL - and all T-SQL procedures (from
> MS SQL Server) should run (perhaps with minor changes) on Sybase ... right?
>
> How much work is it to migrate from MS SQL to Oracle? Will I have to rewrite
> all procedures?
>
> Thanks in advance.
>
> Alexej
  Received on Sun Apr 29 2001 - 23:33:03 CDT