hi, i'm an intending dba and i'll like to know which db to go for: Oracle or Microsoft? please, anyone that can help with reasons for choosing either? thanks
It depends. If you are looking for best performance and scalability, and you can afford a good DBA, then Oracle is best. Otherwise, Microsoft SQL is your best bet. Don't get me wrong, I am not putting down MSSQL... MSSQL databases are simple to maintain and there is not much of a learning curve relating to administration.
wasnt oracle sold recently? I would go with microsoft, who knows if the new company will screw oracle up.
Oracle wasn't sold. They acquired SUN which should significantly bolster the potential advancements in the products and platform they offer. It still leaves a bit of a gray area for the future of MySQL but all is well for the time being. As to answer the question above, it may just come down to money. It's generally accepted that businesses migrate to MSSQL or Oracle once they outgrow the cheaper or free solutions available. MySQL can scale very well, but comes up far short on many of the more advanced tasks that MSSQL and Oracle support. On a straight feature level comparison, Oracle is unbeatable. Luckily, 99% of us will never need to use those very advanced features. MSSQL is a great database that supports replication very well, and can scale very large. The downside of both Oracle and MSSQL is the cost. You easily get into the $200,000+ costs just for initial licensing when you need to scale to enterprise levels. MSSQL is about 1/2 the cost of Oracle once you reach a certain point, but is still in the tens to hundreds of thousands of dollars for licensing. I always recommend using MySQL or PostGre and push it to the limits. Realistically, they can both scale to the needs of 95% of businesses out there. For MySQL, especially when using the Percona, or Google distributions and patches. You may need to drop $50,000 in hardware, but you would be spending the same amount regardless of the database software if you need to get to that level. If it isn't justified, there's no reason to spend a quarter million on software when there's something free that may be able to do the same thing.
It depends ... for what? For quick development? For costs on DB adminsitrators and development? For quick easy tools (experienced or non experienced users)? For price? You must be much more concrete. Both systems are good, both has stronger and weaker sides.
I think Oracle: 1. It can be installed on different OS platforms. MS SQL can't 2. Oracle support is better - my experience 3. Unfortunately Oracle is expensive compared to MS SQL but it worths
I prefer everything come from Microsoft. so I think MS SQL is the best database on the planet , though my nickname is The Oracle
Hi.. Oracle have more benefits, it can run on any platform such as LINUX, Windows, Sun Solaris, etc. Ms. SQL Server just can running on Windows OS Platform. For stability both of them almost same cause Microsoft have been upgrade performance in SQL 2008. You can choose both of them depend on your project needs. Thanks.
I think mysql and postgre can scale up far more than given credit for. Unless you're facebook or amazon or twitter or google, you probably don't need to advance beyond these open alternatives.
Hello, One's personal opinion about this is not so relevant. When reading DB articles, it seems accepted that Oracle is the leading product right now. But there is more than one good performer: - Microsoft - Oracle - IBM - Teradata Also, I would like to point out that when your ambition is to become a DBA, that you should perhaps not seek for the best product, but do an analysis on the Demand and Supply story. Are big companies in your neighbourhood seeking for DBA's?
Microsoft SQL Server has a stronger security posture than the Oracle RDBMS. Three words: Security Development Lifecycle – SDL. SDL is far and above the mostimportant factor. if security robustness and a high degree of assurance are concerns when looking to purchase database server software – given these results one should not be looking at Oracle as a serious contender.