RE: To Sql Server???
- From: "Leslie Tierstein" <leslie.tierstein@xxxxxxxxxxxxxxx>
- To: <Michael.Kline@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 May 2005 08:20:51 -0700
LOL. Really Loud.=20
I work for a company that sells an ETL tool that runs on both SQLServer
and Oracle. Two completely distinct versions of the software are
maintained. Of course, the procedural code (PL/SQL vs. Transact-SQL) is
totally different, and would require a complete rewrite; not only that,
a complete rethink. You've tuned the database for Oracle; however, the
application code also needs to be tuned. It's always a disaster when we
try to take application logic that runs well on Oracle and translate it,
line by line, to SQL Server. Doesn't perform at all.=20
Some of the SQL syntax is also different (Don't know what happened to
standards). The things I can remember off the top of my head are Create
Table as Select; and UPDATE and INSERT with embedded sub-queries.=20
I just ran across a fairly good article which concentrates on
architectural differences between SQL Serve and Oracle, including the
concurrency issues you mention. See:
http://www.wisdomforce.com/dweb/resources/docs/MSSQL2005_ORACLE10g_compa
re.pdf
But at least the application is on 7.3 and therefore can't be using
partitions. Don't even go close to there in SQL Server.
Leslie
Leslie Tierstein
Senior Consultant
Vision Chain, Inc.
The first software to power the demand data network
phone: 202-459-4129
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kline.Michael
Sent: Thursday, May 26, 2005 10:04 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: To Sql Server???
I've got a client who think they are going to take a highly tailored
Oracle subscription system written in UniFace and C and take it to Sql
Server. From the most I can gather, this is going to happen simply
because new management wills it to be so.
=20
This system does subscriptions and of those, there are many, many
different types, some with promotions and all sort of highly complex
views and triggers and about 40 GB of data.
=20
The system current runs on Oracle 7.3.4 on an old Unix box, and sustains
several hundred I/O per second and I've got it tuned that normally they
get ZERO data block waits. The vendor is supposedly "almost there" with
a version 9 of the product. They also use several specialized products
for printing and maintaining zip codes that currently run on the Unix
box.
=20
Still "That doesn't matter. We have willed it to be Sql Server."
=20
I don't think this is going to happen, and HEAD management has "cleaned
house" with middle management before.
=20
But, what might be key "business case items" to consider in such a move?
After all, if this is to be considered "by the will of management" what
might be some good "It will" or "It may not work because..." items?
Other than the obvious, "If you mess this up, you could bring the
company down."
=20
The vendor has mentioned that an Oracle trigger may be 8-15 lines and a
similar trigger under Sql Server could be 150-350 lines. (They have some
products that do run on Sql Server.) The application has hundreds of
triggers, mostly due to UniFace on the client.
=20
(On Oracle this is a very badly coded application that does a lot of
full table scans, etc. Fortunately with all the views, I've been able to
add indexes and tweak the views, etc.)
=20
Michael Kline=20
=20
*************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other
use of or taking action in reliance upon this information by persons or
entities other than the intended recipient is prohibited. If you have
received this email in error please contact the sender and delete the
material from any computer.=20
=20
Seeing Beyond Money is a service mark of SunTrust Banks, Inc.=20
=20
[ST:XCL]
*************************************************=20
=20
=20
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
