Oracle vs SQL Server
| From: | Florian Clever | Date: | Thu, 26 Oct 2000 06:08:42 +0000 |
| Subject: | Oracle vs SQL Server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-3923@lists.php.net to get a copy of this message | ||
>We're currently thinking about buying a new DBMS. I'd like to know from
>more experienced people than I, what are pros and cons about Oracle and SQL
>Server.
I have used MS SQL Server on several Windows NT only projects with ASP
and ActiveX. I have used Oracle 8i with PHP. After getting used to
Oracle, PL/SQL cursors etc., and Oracle 8i Java options I started
complaining about MS SQL Server. MS SQL Server lacks many features of
Oracle, so if you need the best of the best pick Oracle.
The downside is, that in order to be able actually utilize all the nifty
Oracle tricks you need pretty skilled programmers. And Oracle is pretty
expensive. Another thing about Oracle is that it is a little thougher to
administer.
So I would choose Oracle on projects where you have enough skilled
manpower.
>Can anyone explain me what strategy is Oracle using ?
>I don't understand this strategy. You can download oracle8i. Do you need
>some more things to be able to use it ?
>It doesn't seem that the version is limited. What can't you do with it ?
Well you may download it but only for development. So for a production
RDBMS you need a license.
>Is Oracle8i limited to small database ?
No as I said before Oracle 8i is the very best.
--
Florian Clever
fc@clever-soft.com
http://www.Clever-Software-Solutions.de/
PGP Key @ ldap://certserver.pgp.net/
* On the keyboard of life, always keep one finger on the escape key. *