Re: SQL-SERVER vs. Oracle

MS SQL Server is much easier to pick-up on and learn if you're a new DBA. Don't let its ease of use let you think that it can't compete well with Oracle. I have extensive experience in both of these technologies (SQL Server 6.5 / 7.0 and Oracle 8i), and I've had to learn them both on my own. SQL Server 6.5 was extremely stable but lacked a little functionality that 7.0 has taken care of.

As far as a database solution for Windows NT, I would definately give Microsoft the edge here. You can do everything you need to do to a database from the SQL Server GUI tool (Enterprise Manager). Oracle's attempt at recreating this product for their database falls well short. Of course, this doesn't really bother Oracle DBAs because they've become accustomed to doing everything via the command line. Not only in the GUI useless (except to view objects and, on a limited scale, create/alter objects), but Oracle requires way too much digging around in the NT file system and registry. No DBA should ever have to worry about registry entries, ever!!! MS-SQL gives you the added advantage of running over plain old IP or named pipes without the overhead of wrapping a Net8 over it as well.

I don't mean to show a bias here, but the bottom line is, if you want a stable and easy to use solution running on NT, my vote is MS SQL Server 7.0....hands down.

Hope this helps.

Owen Southwood <owen_at_listers.co.uk> wrote in message news:948387115.9283.0.nnrp-08.c2de2f84_at_news.demon.co.uk...
> Of course, I meant "SQL-Server" not just "SQL" !! sorry.
>
>
Received on Fri Jan 21 2000 - 13:28:30 CST