MySQL Forums
Forum List  »  Newbie

Any tips for an MS SQL DBA trying to break into MySQL?
Posted by: Sam Alexander
Date: January 25, 2012 08:16AM

Hi everyone,

I've been an MS SQL developer for over a decade now, but other than using MySQL on a few sites I maintain I've never really learned the nuts and bolts of MySQL. Some questions for anyone who's gone down this same path or who works in both worlds:

- Is there an SSMS type tool for MySQL? I've tried MySQL Workbench but it just seems clunky. Also if possible i"d love to find something that works in Windows, Linux, and OSX since I live in all three worlds.
- Can someone recommend books or online resources about indexing and performance tuning?
- I use Microsoft SQL Server Reporting Services and love it, is there any equivalent tool for MySQL whether by Oracle or someone else?
- What about equivalent troubleshooting tools in MySQL like these in MS SQL: information_schema, SQL Profiler, DBCC SHOWCONTIG, etc.
- Also any good books or resources showing how MySQL works under the hood? I'm familiar with the tree/leaf method of how MS SQL works with indexes but what about MySQL?
- What about data warehousing? MS SQL has Analysis Services, but are there any tools either built into MySQL or maybe industry standard tools for business intelligence?

Thanks in advance for any pointers or tips. Take care,


Options: ReplyQuote

Written By
Any tips for an MS SQL DBA trying to break into MySQL?
January 25, 2012 08:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.