Link to home
Start Free TrialLog in
Avatar of Ricky White
Ricky WhiteFlag for United States of America

asked on

Sql Server or Oracle Database?

What are the scenarios in which a Database should preferably be made in Oracle as opposed to Sql Server?
In other words are there any limitations in Sql Server in terms of performance, Functionality, etc that are better addressed in Oracle?
Avatar of sammySeltzer
sammySeltzer
Flag of United States of America image

Scalability, from my experience, used to be an issue but that gap started getting addressed from sql server 2005 and now, with sql server 2008, I don't think that gap exists anymore.

Besides, I think that Oracle is unnecessarily too complex.

Finally,  a majority of markets out there use sql server.

I am not an advocate for Microsoft by the way - just my experience having used both.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I agree with acperkins...

As an Oracle Resource.. I think oracle has a better tendency in case of robustness or performance and the tools/resources available in market makes it easy to manage.!!
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ricky White

ASKER

Thank you all! So from what I gather they pretty much serve the same purpose and are pretty competitive. But How about the new Sql Server products like SSIS, SQL Reporting Services, etc Does Oracle have functionalities like those?
Oracle has corresponding utilities or product, cost should be calculated carefully
But How about the new Sql Server products like SSIS, SQL Reporting Services, etc Does
Oracle have functionalities like those?

Of course, but you are missing the point.  Just for arguments sake, let assume your team has Oracle expertise and you decide that based solely on functinality you are going to go for SQL Server.  Even if Oracle is $20K (this is just a number) more expensive than SQL Server, can you honestly justify that is going to outweigh re-training all your team?  If you do, you are in for a rude awakening.
Thanks All!
Its been very helpful!