Search code examples
mysqlsqlyog

MySQL managers. What are advantages and shortcomings of the SQLyog and EMS SQl Manager

I need to find most useful MySQL manager. And I found SQLyog and EMS SQL like most popular. Maybe I'm not right. So, please, advise me something.

Solution

  • Definitely a subjective issue. From my experience:

    SQL YOG

    • More comfortable work with many open queries.
    • Better export options.
    • Better at auto formatting queries.

    EMS

    • Faster!
    • On connecting, reopens all queries you had open the last time you were connected to each DB. Very helpful.
    • DB connections tree easier to use when working with many DBs.

    Bottom line: I prefer EMS, but when I have to export large amounts of data I use YOG.

    Hope this will help you choose. They're both good.