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

[Stevenson]

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

 

[Terpsfan]

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.

 

[seefire]

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

 

[Guest_imported]

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

http://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.