The moose likes JDBC and Relational Databases and the fly likes SQL Server vs Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Server vs Oracle" Watch "SQL Server vs Oracle" New topic

SQL Server vs Oracle

Nidhi Singhal
Ranch Hand

Joined: Sep 19, 2004
Posts: 89


I want to know that while developing a java application, which would be a better choice for the database - SQL Server or Oracle?

Thanks & Regards,

Makarand Parab
Ranch Hand

Joined: Dec 10, 2004
Posts: 121
Hi Nidhi
Both the database are good. Just have a look at your comfort level with both the database and then select the one. I would prefer Oracle, reason coz i have already worked using that database.


lei zhang

Joined: Sep 15, 2004
Posts: 14
hi Nidhi

the both are good ,but for you , which one you chose in a project that thinking about the size of this project

i like oracle,SQL server is bother,uninstalling it is very trivial,then,you uninstalled it take you a lot time,but you insatll it again,there has a mistake for installing it,
on all account,for installing it ,i installed my system several again.
it very bad!!

people laugh and people cry.some give up some always try.some say hi while some say bye.others may forget you but never i!!
praveen kanakarajan
Ranch Hand

Joined: Apr 27, 2005
Posts: 54
i had worked on oracle and sqlserver 7.both are having advantages of its own.I had make some workaround in writing programs while using sqlserver where i had to get the rownumber ,sequence (theres an option in sqlserver IDENTITY) for some purpose. i would say i'll go for oracle rather than said by other friends,it depends on one's comfortability and size and of the feature i liked abt sql server is the diagrams which is helpful in setting relations.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63852

"praveen k",

There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Forum Bartender

[Asking smart questions] [About Bear] [Books by Bear]
I agree. Here's the link:
subject: SQL Server vs Oracle
It's not a secret anymore!