Re: Oracle vs. Sybase

Once upon a time it would have been far easier to migrate to Sybase. Depending upon what SQL Server features you have used that is no longer the case. But quite frankly the biggest concerns I would have going to Sybase vs. Oracle would be:

1. The lack of third-party tools and support
2. The lack of books at the local bookstore
3. The very real possibility that Sybase may go out of business as its marketshare is becoming insignificant.

Daniel A. Morgan

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 22 2001 - 00:22:27 CDT