From oracle-l-bounce@freelists.org Thu May 26 10:36:04 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4QFa495015774 for ; Thu, 26 May 2005 10:36:04 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4QFa3Ni015769 for ; Thu, 26 May 2005 10:36:03 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 049111B1A40; Thu, 26 May 2005 09:32:46 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01742-01; Thu, 26 May 2005 09:32:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B5C31B15DE; Thu, 26 May 2005 09:32:45 -0500 (EST) From: "Igor Neyman" To: , , Subject: RE: To Sql Server??? Date: Thu, 26 May 2005 10:30:53 -0400 Message-ID: <000c01c561ff$8584e100$2004a8c0@development.perceptron.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: <200505261420.j4QEKE639683@cadre5.com> X-archive-position: 20334 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: ineyman@perceptron.com Precedence: normal Reply-To: ineyman@perceptron.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=AWL,EXCUSE_16 autolearn=no version=2.63 Also, SQL Server doesn't have a variety of triggers Oracle has: before/after, row_level/statement_level. All it has is "before" trigger on statement_level. Igor Neyman, OCP DBA ineyman@perceptron.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Vlado Barun Sent: Thursday, May 26, 2005 9:20 AM To: Michael.Kline@SunTrust.com; oracle-l@freelists.org Subject: RE: To Sql Server??? One of the major differences between SQLServer and Oracle is the Concurrency Control. See Tom Kyte's Expert One-on-One book, pg 123 - 133 and do a search on asktom.oracle.com In summary, you can't just translate your PL/SQL procs and triggers to T-sql. You have to recode the way the data is accessed to compensate for the difference in the Concurrency control between SQLServer and Oracle. Unless, of course, your management doesn't care about performance and scalability... And don't forget, there are many other differences you will have to worry about... Vlado Barun, M.Sc. Senior Data Architect, Cadre5 www.cadre5.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Kline.Michael Sent: Thursday, May 26, 2005 10:04 AM To: oracle-l@freelists.org 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. 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. 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. Still "That doesn't matter. We have willed it to be Sql Server." I don't think this is going to happen, and HEAD management has "cleaned house" with middle management before. 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." 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. (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.) Michael Kline ************************************************* 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. Seeing Beyond Money is a service mark of SunTrust Banks, Inc. [ST:XCL] ************************************************* -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l