Re: Sybase to Oracle Migration

The technical benefit from moving from Sybase to Oracle depend on several factors not mentioned in your post:

Are you migrating to the standard or Enterprise edition of Oracle?

Do you have plans to make use of any Oracle feature that has no direct equilivent in Sysbase once the migration is accomplished?

Is your application experiencing specific problems because of the interaction (conflict) between the way it is designed and the way Sysbase works or is it running into any Sysbase limitations.

In general Oracle can handle large concurrent user loads, large physical databases, and the combination of the two as well as or better than competing rdbms products. Oracle is suitable for OLTP, OLAP, DSS, and Warehouse environments and can be configured to perform reasonably well when these types of application are run combined into one database at the same time.

Oracle does however have a very different read consistency model than some of its competitors so code cannot just be ported between different rdbms products and ran as is. Just because the code runs, does not mean it works correctly. Thought has to be given to the possible side effect of the consistency model.

HTH -- Mark D Powell -- Received on Fri Dec 17 2004 - 07:33:16 CST