×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Oracle 8i or SQL server???????????

Oracle 8i or SQL server???????????

Oracle 8i or SQL server???????????

(OP)
Hi,

Can anybody give me a Comparision of the 2 most widely used
Databases Oracle 8i and SQL Server.
We have to use one of these as the Database
in a VB 6.0 Project which is right now working with MS-Access
Database. since the Database is growing big we have to shift
to a bigger database.
so please give some suggestions which one to use SQL Server or
Oracle 8i ??????
which is the best among the two ?

Thanx in Advance
Steve

RE: Oracle 8i or SQL server???????????

Both databases are comparable to each other in offering enterprise-level applications.  Both offer outstanding support for security and web interfaces.  However it's been proven that SQL Server 2000 is a faster and more cost-effective database management system than Oracle.  Another words Oracle, while having the prestige, also costs up the yin yang to run. Oracle support is ungodly priced.  Since you have already used Micrsoft Access and Visual Basic, I'd use SQL Server.  Visual Basic isn't normally used with Oracle.  I've found SQL Server to be a much more user friendly database and it's much easier to set up and learn than Oracle.

RE: Oracle 8i or SQL server???????????

Hi Wilson

You have raised a very interesting question. To my knowledge if you compare sql server with oracle 8i. 8i is a better RDBMS because of following features.

8i is not just a database.  8i is a Object Oriented Relational Database Management System with Internet support.  It offers various feature which are no where available in sql server.  8i helps you to manage the database using the internet itself.  The concept and the security implemented in oracle 8i is tremendous.

Based the amount of data and the security purposes, you can decide upon oracle or sql server.  Sql server is comparitvely cheaper and easier to manage.  Whereas it is not the same in 8i.  If you looking into easier access you can go for sql server, otherwise 8i is a better option which has more stability and security.

Hope this helps you

RE: Oracle 8i or SQL server???????????

This apinion is based on my expirience (3 years Oracle and 1.5 yars MS SQL)

I think that for you will be more easy to migrate to MS SQL, I mean cheeper and faster.

Generaly I think that Oracle RDBMS form 7.3.4 to 8.1.7 are better than every one MS SQL Server database from last 2 years.

This is becouse Oracle DB have better :
Security,
Internet Support Options,
Object Oriented,
Stabile,
Faster (if you tune it corect),
many different usefull types of data not supp. from SQL,
DataBase Packeges (Oracle packeges are very simular to classes in c++),
Build-in Java support,
Oracle run on every OS (allmost),
Very good CORBA support (If you choose OAS),
and many other things.

It is true that Oracle DB is not so user frendly (but you are not a user - you must be a proffesoinal).
Oracle have some kind of USER GUI, but I for example do not preffer to use it. I recomend you to do the same and to use Oracle SQL Plus (this is a SQL command line terminal)for database management porpuses.

If you choose MS SQL the things will be trivial for you.

If you choose Oracle you will have few posabilities to connect "client" whith "server":
1. To use ODBC - no comments
2. To use OLEDB provider - no comments
3. To use DLL variant of Oracle Call Interface - OCI (OCI32.DLL). This is natural API provided from Oracle for connection whith DataBase. By my opinion this is the best way. The OCI and Docs about it you can find on Oracle Database Install Disk or www.oracle.com .

Unfortunately I am not a VB programmer and can not give to you example source for OCI on VB, but if you want I can give to you example source on C++ whitch use OCI32.DLL
I belive that you will easy translate to VB.

My address is boko@bitex.com


P.S.

Pleace excuse my bad English.
It is my 3-th language.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close