Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote -1 down vote favorite

I have worked with MSSQL for a while now, but now we want to try to move to some open source for a specific part of the company's products or explore Oracle if possible. What would you say are the main differences between the Database Administration Capabilities between MySql and Oracle?. Can I do the job with any of them the same?

share|improve this question
MySQL is very different to SQL Server and Oracle - I'm not saying it does not have it's uses, but comparing MySQL to those two is a case of apples and oranges. Postgres is far more likely to be a suitable replacement for SQL Server (even more so in the case of Oracle) – Jack Douglas♦ Mar 27 '12 at 12:52
VTC'd. This question is troll bait of the first water and they're already coming out to play. If you want to get a meaningful answer you need to ask something a whole lot more specific. – ConcernedOfTunbridgeWells Mar 27 '12 at 13:02

closed as not a real question by Leigh Riffel, ConcernedOfTunbridgeWells, gbn, Mark Storey-Smith, Jack Douglas♦ Mar 27 '12 at 13:47

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.

2 Answers

up vote 2 down vote

Oracle is a Humvee, MySQL is a Camry or Prius, while SQL Server is a RAM truck (in between the two).

However you can follow http://mysql-dba-journey.blogspot.com/ for insights of an Oracle DBA to MySQl. Alot has changed over the past year but it still a good primer.

share|improve this answer
3  
I look at it more like this: Oracle and SQLServer are rivals Kingdoms, while MySQL is Robin Hood. Robin Hood's Goal? Rob from the Rich, and Give it the Poor. The Rich are those with open checkbooks, no budget constraints, and in need of a Solid Database Product. The poor are those with limited budgets but want the same things in life the Rich want: a Solid Database Product. MySQL can do the job. Oracle is still supporting it in terms of improvements to InnoDB. +1 for your immediate descriptions of Oracle, MySQL, and SQLServer. – RolandoMySQLDBA Mar 15 '12 at 17:36
MySQL = Camry? It's more to a Corolla..... – Fabricio Araujo Mar 26 '12 at 20:01
up vote -1 down vote

Yes exactly! MySQL is no doubt the best OpenSource Alternative to Oracle or MSSQL. And that too for free.

And you can almost do all the things as a DBA that are supported to Oracle DBA, but may be in different ways. For Eg: Oracle provides different type backup facilities like cold backup, hot backup, export, import, data pump. Oracle offers most popular backup utility called Recovery Manager (RMAN). Using RMAN we can automate our backup scheduling and recovery database using very few command or stored scripts.

MySQL has mysqldump and mysqlhotcopy backup utilities. There is no utility like RMAN in MySQL.

Where as one More Database thats opensource and that is PostgreSQL http://www.postgresql.org/

for more: http://www.dbametrix.com/comp-oracle-mysql.html

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.