SQL Server vs. Oracle 8

Given a committment to development in VB5/6, which would be the better database server to use, and why?  The typical use would be for applications with 50-100 users, and occasional access necessary via a WAN.  Client currently has a Netware 4.xx system going with Win 95 workstations.  If I left out any critical variables, please let me know and I'll fill in whatever blanks I can.

If there is any documentation that's been done comparing the two, it'd be great to know where it is.

Thanks!
ggloverAsked:
Who is Participating?
 
dr00pyConnect With a Mentor Commented:
If you're new to a database then I would propose Oracle. The oracle interface is much friendlier and easier to use then the MS-Sql server.
SQL-Server is made with all it needs to perform fast databases. They just didn't make a descend user interface.
If you want to wait for version 7 of SQL server, you'll notice a complete rewritten interface. (so .. you'll have to start all over again with learning to use the software.)
Also ... SQL server is best run under Windows NT-server.
Oracle has no problems running on a netware server.

General conclusion...
If you need to start from scratch .. Use Oracle.

Myself, I've used both and I prefer SQL server but then again ... I'm used to work with dumb interfaces (unix-like) and I was used to work with Sql-databases before I started to use SQL-server.
My customers have both..

For the VB code, it doesn't make a big difference ...
For the managment part of the database ... it makes a big difference.

HINT ...
Make shure that there is enough memory in the Database-Server PC (oracle or MS).
The more memory is available .. the faster your database will run.
0
 
ggloverAuthor Commented:
So Oracle is easier to maintain?  What about performance and cost issues?  

Thanks for your input.
0
 
dr00pyCommented:
For Price issues you can visit:
ORACLE:
http://oraclestore.oracle.com/orastore/plsql/doc.show
You will also find some very usefull information on Oracle

Microsoft SQL Server:
http://www.microsoft.com/products/prodref/152_ov.htm
Same thing over here ..

For a compare of the different Sql-Servers:
http://ntsolutions.oracle.com/html/BRG_wp.htm
This document is a very nice piece of work .. It's an oracle document.. ok .. BUT!! it's a correct document ..
One notice about it ...
Don't only look at the result values .. also take good look at the detail-information .. this way, you'll get a global idee of cost and performance.

Have fun reading ..
Alex
0
 
ggloverAuthor Commented:
Thanks for the info, Alex.

-G

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.