OK. Thats all accepted. Hope I didnt offend the SPCA or any animal lovers
with my reference to sheep?
Obviously my next step is to present the boss with all this and argue for
the abandonment of SQL server for the application. I just spoke to MS them
selves about it all, and there line is that the most serious feature of SQL
Server to consider is the TCO. (Total cost of ownership) Need I say anymore?
We are also evaluation ADO right now, and it looks quite good so far.
-----Original Message-----
From: Nic Wise <[EMAIL PROTECTED]>
To: Multiple recipients of list database <[EMAIL PROTECTED]>
Date: Tuesday, 9 November 1999 8:42 AM
Subject: Re: [DUG-DB]: Cascade deletes using Triggers in SQL7 V Interbase
> I'm not a sheep... I use ORACLE... The question I have is this.... I've
been
> playing with the D5 evaluation and have utilised ADO to ORACLE for a
> couple of tests and can find no obvious limitations but this is by no
means
> a comprehensive test. Does anyone know of an issues or limitations
> document expressing information about the MS ADO driver for ORACLE...
Sorry, I havne't seen anything, tho if the driver is from MS, looking on
MSDN would be a very good start. or Oracle.com
> I'm sure ORACLE is working on one themselves... ;)
I hope so - for their sake.
> NB: ORACLE has before and after triggers, along with full support for
> INTERSECT
> and a number of other functions that people seem to list as being quite
> rare.
Yup, Oracle is, IMO, about a good as it gets for very LARGE DB's - ie,
running on high-end hardware with staff supporting it. For embeded
systems, with no DBA on hand, IB, for me, takes the cake every time.
Especially the Linux version :)
My opinion: (and it IS MINE, not Inprise's)
Do it properly with a big budget: get Oracle and a DBA or 2
Do it properly without a big budget: get Interbase
Want a support nightmare: get MSSQL without a DBA.
There again, I work for Inprise, so I'm atleast somewhat biased, tho
most of this opinion was formed before I worked for Inprise, when I was
working for an MS shop (Glazier - can you GET more MS-focused?)
N
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
