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?
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.
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.
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/