Disclaimer and Update: I now work FOR Oracle. So keep that in mind when you read these posts. Of course I wrote them BEFORE I started at Oracle, but I still figure you ought to know that…does that mean I think that Oracle wins the debate now? I’ll let you guess how that works
I’ve worked with Oracle since 1999. Oracle’s database technology debuted in 1979, years before Microsoft OEM’d Sybase’ database. You’re just waiting to here me say ‘Yes, Oracle is better!’ Well, I’m not going to say that. Both database platforms are legitimate solutions, and it would be hard to find a clear ‘winner’ without some form of bias entering the equation. I hope that you spend a lot of time developing your core requirements before you decide which way to go. In the meantime, I’d like to share some of the things I find ‘cool’ about both platforms.
Why Oracle Wins
Oracle goes first because I’ve been using it longer and it happens to come first in the alphabet.
Why SQL Server is EVERYWHERE
Listed second, but doesn’t come in 2nd place in very many aspects when compared to Oracle.
We all do. You can’t really go wrong choosing either platform to build a career or application on. I have seen both databases perform extremely well in the industry standard benchmarks, but more importantly, I’ve seen both running in the real world by real customers for real applications.
Shameless Plug for T-SQL to Oracle SQL Translator
If you’re here I’m guessing you did a search on Google for Oracle vs SQL or similar. That tells me you’re trying to make a platform decision, win a bar bet, or trying to figure out how to do something in Oracle like you already know how to do in SQL Server. If you’re in the latter camp, check out our SQL translator. It’s built right into our default IDE, aka SQL Developer.
So what did I leave out?
I’d love to hear why you love Oracle or SQL Server or both! And that goes double for people who have actually worked with both platforms.