Ricky White
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?
In other words are there any limitations in Sql Server in terms of performance, Functionality, etc that are better addressed in Oracle?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.!!
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Thanks All!
Its been very helpful!
Its been very helpful!
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.