SQL Server vs Oracle

[Nidhi Singhal]

Hi,

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,

Nidhi

[Makarand Parab]

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.

enjoy

Regards
Makarand

[lei zhang]

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!!

[praveen kanakarajan]

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 sqlserver.as said by other friends,it depends on one's comfortability and size and complexity.one of the feature i liked abt sql server is the diagrams which is helpful in setting relations.

[Bear Bibeault]

"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.

Thanks!
bear
Forum Bartender