I'm studying SQL Server but don't know much about Oracle. Can anyone give me a fair comparison of them? I've read a comparison about SQL Server 2000 vs Oracle 9i, but it's a little out of date. Have SQL server 2008 caught up Oracle 11g/i yet?
In short, both Oracle and SQL Server are powerful RDBMS options. Although there are a number of differences in how they work “under the hood,” they can both be used in roughly equivalent ways. Neither is objectively better than the other, but some situations may be more favorable to a particular choice.
SQL Server is a good option if speed and processing power are not your main concern. Even non-technical users can learn it faster than Oracle and it has most of the features of other traditional RDBMSs. Either way, both databases are assets for your business and will help manage your customers and employees in tandem.
KEY DIFFERENCEOracle allows rollback during the transaction process whereas SQL server doesn't allow rollback in the transaction process. Oracle supports many “Schemas” with the instance whereas SQL server offers “Schemas” within each user database.
No. Oracle Server is owned by Oracle. SQL Server is developed by Microsoft. Oracle uses PL/SQL.
Just my $0.02 after working with SqlServer for years and Oracle for 4 months now.
SqlServer is much easier to use, this allows you to concentrate on what you want the database to do (solve some business problems) instead of wrestling the server all the time.
Because Oracle makes you configure so many settings, there are a lot of ways to get them wrong. This leads to endless discussions about partitioning, the type of index to use, etc etc. During those discussions, nobody is thinking about the business problems.
An analogy: I once had a olympus camera with a good lens and some simple settings. I made nice pictures with it so I upgraded to a DSLR with all kinds of knobs and dials. With that my pictures weren't half as good because I was concentrating on the camera instead of the subject.
That to me is the difference between Sql and Oracle. Sql is easier to work with and therefore gets more things done. Ideas go from the whiteboard to working code so much faster. Only when you push for very large databases that Oracle might take the edge but I'm not even sure of that. I don't think there's something that Oracle could handle that SQL couldn't.
Edit: Also, Oracle is very poor at in-database analytics on large data volumes because of context switching to PL/SQL. So if you have a few complex functions you want to run on your data, don't use Oracle. MS SQL on the other hand shines in this area because it does not suffer from this issue and also has .Net integration.
I'd say:
If I were to choose I'd go for SQL server because of the better optimizer. However, I don't really feel safe when multiple people use the same rows in SQL server.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With