Gay Male Anthony Mandic wrote:
I agree. But putting aside the marketing hyperbole ... it is a major
change in concepts and architecture and should not be undertaken without
a thorough understanding of the major differences (far more than just
syntax) between the two products.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Gay Male Anthony Mandic wrote:
To convert Oracle to Sybase there ae a number of products. But all they
do is get you started. Not one of them can turn autonumbering into
sequences with before insert triggers. Not one of them can not create
temporary tables and create in-line views in their place. Not one can
change your code to an environment where reads don't block writes and
writes don't block reads.

They are starting points ... but after that of little or no value. Some
of the worst PL/SQL I have ever seen was from a SQL Server database
converted to Oracle by people that thought because it compiled it would
run. And run it did. Right into massive data corruption.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Doing a strict "conversion" will do only one thing. You will end up with a
poor substitute for what you originally used. This is actualy true of any
software.

Oracle has so many "features" in PL/SQL doing a straight conversion from
T-SQL to PL/SQL would not yield optimum results. There are objects in
PL/SQL such as packages that can change the way thing are developed. I used
to be product manager for a tool that accessed all the major database
systems and was constantly asked for a "translator".

For each request I would ask the same question as to how to convert a single
feature from one database to the other. I never got the same answer twice.
That is why (over and above the money grab for consultants) the available
tools come with a consultant.


"Daniel Morgan" <damorgan@x.washington.edu> wrote

Hi

I recently converted syabse to oracle.Go to otn.oracle.com and
download oracle migration workbench which is FREE..registration at otn
is also free..migration workbench does a deecnt jobs..it does create
temporary tables,sequences and data functions etc..however you need to
look at performance..as migration owrkbnech does a one to one mapping
:-)..

regards
Hrishy

How'd they do that? wrote:
Depends on what they bought to serve what purposes. If you go to
http://store.oracle.com and look up Oracle Standard Edition One you can
be fully licensed for under $1000 US. Could DB2 or any other RDBMS be
less expensive? Possibly but by how much?

If on the other hand your employer bought Enterprise Edition for a 32
CPU OS/390, 9iAS web-application server, a top-line support contract I
would expect they'd pay in 7 figures.

You can only compare pricing if you know what was compared with what
including what features. And one must also leave open the possibility
that the employer, not understanding the differences between Standard
Edition and Enterprise edition, etc. could have been quoted on far more
than was required. Perhaps also the IBM salesperson didn't explain the
fact that DB2 has no security other than that provided by the operating
system and for $X they would need to purchase Tivoli to come close to
the built-in security that comes with Oracle.

But even if any single product is more expensive the cost of the
RDBMS,itself, is rarely a major part of the TCO. And you must always ask
questions such as what features do I need to meet the system's requirements.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Hi

The TCO approach would look very very different...you cannot really
compare TCO approach with oracle and Db2...Becuase IBM to a certain
extent can make you beleive that DB2 is cheap..thats what it will do
in the years to come..remember IBM is a infrastrucutre apart from
being a consultancy and development organistaion..IBM consultants can
bundle a AIX Linux on a p series and give away Db2 and Trivoli for
free or at a throw away price...and for integration they can always
bundle it with websphere adding icing to the cake..so obivoulsy your
TCO would be skewed towards IBM..the temptation would be
irresistable..

suggest you try a relaxed and a prototype driven approach when you
take up migration driven projects..

regards
Hrishy


Daniel Morgan <damorgan@x.washington.edu> wrote