Re: SQL Server 6.5 v Oracle 8

Stephen,

We use Oracle v7 & v8, Sybase 10,11 & Adaptative Server, SQL 6.0/6.5 and now looking at the Beta release of v7 (as well as DB2/400) - boy oh boy is Oracle the biggest nightmare! - Text Field sizes, memo type field restrictions, disk fragmentation (yes still there in abundance) - horrendous to backup and definately very much more work than say SQL, but then I guess SQL (well v6# anyway) is a bit more of a lightweight animal, I'm sure an Oracle buff will extol it's virtues continuously but for me delaing with a little bit of each I know which one I always hope our clients don't want..........

I have to sat though v8 is better than v7.

Stephen Dance wrote:

> It is possible that we may be soon using Oracle 8 on NT 4.0 to run a large
> financial app.
>
> Although I've been running our MS SQL Servers for the last few years
> (versions 4.21, 6.0 & 6.5) I havn't seen Oracle since the days of V6 on Unix
> (about 5 years)
>
> SQL 6.5 has been a doddle to look after - automated nightly backup, DB
> sanity check and allocation check, weekly update statistics and rebuild
> indexes job.
>
> - what can I expect from Oracle 8 on NT regarding routine housekeeping and
> generally looking after it ?? - I remember from the Oracle V6 days that it
> could be a bit of a nightmare, especially dealing with fragmentation and
> keeping performance high.
>
> Thanks
>
> STEVE
>
> --
> Spamtrapped
> To reply remove D1059
Received on Fri Dec 04 1998 - 07:12:31 CST