Hi Guys,
We are planning to migrate my Sybase Database (Large in size) to
Oracle 9i/10g. Can somebody tell me what are the benefits I get by this
in terms of Technically.

Regards
Sampath

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

I guess you are having some specific problems with your Sybase system
that are unresolvable in that platform? Because it sounds like your
question is putting the cart before the horse. Why would you be
planning to move to Oracle without knowing what the technical benefits
are?

Sybase is a good database. As I have grown more familiar with Oracle I
now think Oracle is superior, but Sybase is very good also. Moving a
"large" database can be a very expensive undertaking, not even counting
the cost of the software. It's a big, big deal. Don't undertake it
lightly.

My $0.02.

Allan

sampath wrote:

I like Mark Powell's response to you so I won't repeat it. But, of
course, knowing more about what you are doing would be a great help
in offering advice.

The one thing you have bought, for certain, is improved employability
prospects. Sybase, for better or worse, has a decreasing market share
and the Oracle experience will be valuable on your resume'.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----

http://www.oracle.com/technology/index.html and type sybase into the
search box.
jg
--
@home.com is bogus.
http://www.newsoftheweird.com/weirdmap.html