I have been working with Sql Server since it’s first introduction. About a year ago, for various business reasons, we decided to port about 100,000 lines of Sql stored procedures to MySQl. We chose the Aurora MySQl version offered by Amazon. At first glance the SQL workbench should have provided all of the necessary functionality. But unfortunately this was not the case. So I started looking for alternatives, the recommended MySql manager did not appear to offer any advantages. Then I came across SQLyog, Hard to pronounce but definitely a better choice. I downloaded the free version to try it out and was instantly sold on the product. After about a week of trying it out we purchased the license to the product. What did it offer:
1.High reliability. The MySQL Workbench would crash for unknown reasons and was not supported on Windows Server, my development environment.
2. More functionality. As you can imagine converting a thousand of stored procedures from Sql Server to MySQL is no small task. After analyzing the code differences I was able to do a general conversion fairly quickly and then tweaking as I debugged the code with my web site code.
3. Backup functionality. Easy to make one file per object backups. This was useful to give me the ability to store my work in SVN so I can track and preserver changes over time, as well as off site backup.
4. Saving the open work files when closing and reopening the program. This is a great handy feature, one I wish Sql Server Manager had.
Improvements needed: the product is great as it stands but I would like to see the following improvements.
1. When opening a stored procedure for alterations position the cursor at the top of the file instead of the bottom of the file, as I seem to always need to go back to the top to start working.
2. Add the standard Cut and paste keystroke functionality every other windows based program has namely Ctrt-X to cut the current line. As well as any other keyboard shortcuts you are missing
3. I know there were a couple of other improvements I would like to see but it slips my mind right now.