Indispensable Mysql Tools

by 1 replies
2
For me, there are two Mysql tools that I couldn't live without:

Sylog - I use the enterprise version (well worth the money) because it has a power tool that will compare two schemas, even on different machines, and build the script to make schema A the same as Schema B. So I can develop on one machine, run a compare, and run a script to make the test machine's schema exactly like the dev environment. When it's time to go to production I generate a "hot patch" script to do the same thing. It's got a ton of other stuff as well. There's a free version, but it doesn't have the power tools.

Dreamcoder for Mysql - It's free and provides an excellent client for doing heavy duty mysql development.

I know most people use phpadmin, but you'll never go back if you use these tools.
#programming #indispensable #mysql #tools
  • I really enjoy using SQLYog. It's great desktop client for managing database. I hate using phpadmin for most tasks although it's a lifesaver at times.

    I'm going to check out dreamcoder. thanks!
Join the discussion

Next Topics on Trending Feed

  • 2

    Indispensable Mysql Tools

    For me, there are two Mysql tools that I couldn't live without: Sylog - I use the enterprise version (well worth the money) because it has a power tool that will compare two schemas, even on different machines, and build the script to make schema A the same as Schema B. So I can develop on one machine, run a compare, and run a script to make the test machine's schema exactly like the dev environment. When it's time to go to production I generate a "hot patch" script to do the same thing. It's got a ton of other stuff as well. There's a free version, but it doesn't have the power tools.