Re: Oracle Vs. SQL SERVER
Date: 22 Nov 1994 23:57:43 GMT
Message-ID: <3au0hn$r2h_at_mother.usf.edu>
In article <khosraf.2.00119998_at_sce.com>, khosraf_at_sce.com (Fereidoon Khosravi) says:
>
>HI!
>
>I am looking for any information you all can share comparing ORACLE and SQL
>SERVER. I am trying to ascertain the difference between the two and advantage
>of using one vs. the other as the backend database server. I would like to
>pick ORACLE (because of my personal experience with ORACLE 5.2- I am a little
>behind I know!) but need to substantiate that with some facts. The front end
>more than likely will be ACCESS (or maybe Pdoxwin). Along the same line, would
>there be any problem using MS OFFICE products with ORACLE. Can they seamlessly
>be integerated? (that is the argument being used -compatibility with MS OFFICE
>- in favor of SQL SERVER that I want to refute, if indeed refutable).
>
I have used both. I find that Oracle runs on just about anything so if multiple platforms are
an issue micro>mini>mainframe Oracle is hard to beat. SQL Server has a nice set of standard
admin tools but similar things can bought for Oracle for a price(Oracle admin tools are barebone).
Oracle does not support running external os (shell commands) processes as does SQL server.
SQL server ODBC drivers
install eaiser on the client side. Oracle does not support OS based security on NT nor direct to
tape backups yet.... SQL server is cheaper (used to be $1495 for unlimited users more like
$14k/1000 users now). Future versions of SQL server may no longer be compatiable with Sybase products
since Microsoft and Sybase divorced. Oracle seems to be more limited than SQL server when
dealing with BLOBs. Yes ACCESS does work with Oracle 7 and other ODBC products but I think
you are supposed to license SQL net and the ODBC driver for each client which I believe SQL
server includes with the server license. Oracle servers require roughly 1MB min per conection
SQL server around 64KB. Future systems such as MS Enterprise EMAIL and HERMES will
probably be based on SQL server
>Reference to any related newspaper/magazine articles will be great too. Thanks
>for your help!
Received on Wed Nov 23 1994 - 00:57:43 CET