Re: Oracle VS SQL Server - Which is best to back end ?

Hi

    Couple of responses regarding Oracle's documentation.     I have used Oracle 8i as well as SQL Server 7/2000. These things stand out:

1. Installing Oracle 8i - First time I installed - It took me 3.5 hours and then my computer blue screened. Put more memory (increased from 128Megs to 384 megs) and was able to install. Try to create a schema from the Enterprise manager - could never use it - had to go to command prompt and do it the "old-fashioned" way - dont know why the UIs are provided. UIs are slow too.

    Compare to SQL Server - easy to install - register a SQL Server and start using enterprise manager - no hassles.

    2. Documentation - SQL Server Books online is the best ever Documentation on a product I have seen. After using Oracle technet - I now am an expert in coining keywords for HTML search:-))

    3. On Oracle's positive side - I must say the XML integration and java enabled programming is pretty cool. I enjoyed writing stuff for implementing these.

        In SQL Servers defense - I must say that you can write whole programs in the stored procedures, T-SQL is strong. And so is PL/SQL.

        BUT what lacks is that I can write a Select in a t-sql stored proc. and return a rowset.

As a developer I rather use SQL server - I need not be a DBA to implement a SQL Server DB.

No offense to anyone here:-))

laski...]

Duncan Hodson <jernau_at_gamesinferno.com> wrote in message news:aJ5t5.8649$6A2.564795_at_nnrp4.clara.net...
> > The documentation is very good. in oracle the documentation is poor. Not
> > even the examples in the documentation work.
>
> I have to disagree with this. My last job was using Oracle, and i'm now
> using SQL server, and i have to say the documentation with Oracle is
 superb.
> I can only say that sql server's books online is average and lacks the
> quality of oracle's. Where the sql server docs say "you can't do this",
> oracle's would say "you can't do this, but you can try this other thing".
 

> :-)
 

> >
> > When writing eg. Procs it is much more easy to use SQLServer if you are
> > going to use Dynamic SQL statements. Oracle is "heavy".
> >
>
> Nah, they're about the same. Oracle 8 has a PL/SQL (procedure) debugger
> built in, and i've yet to find one in sql server.
>
> Perhaps it's the amount of time i've been exposed to Oracle, but i'd
 rather
> be using that than SQL server. It IS more expensive tho. Oracle tech
> support BTW is the best i've ever spoken to out of all the products i've
> been involved with.
>
> Ta
>
> Duncan
>
>
Received on Tue Sep 05 2000 - 15:58:57 CEST