Good Database Tools

Guard Dog · #1 (**permalink**) 07-02-2009

Since I was doing some database work today for several of my sites, I thought I would share a couple of very nice tools to use:

Navicat - Navicat is what I use to attach to my database and run queries. The nice part about this tool is that it allows me to create querys by simply selecting tables and fields (no code writing). I can test those queries and then use them in my programming. Very nice, but does cost $179 (I use Navicat for MySQL since that is my database type)

DBDesigner 4 - DBDesigner is what I use to create my databases. It is a database design software that allows you to model your database and then create the SQL code to create the database (I use Navicat to run the SQL code). Very nice.... FREE.

Anyone else use anything different?

Guard Dog · #2 (**permalink**) 07-02-2009

Another good program that's free:

MySQL Workbench - At MySQL.com, this one allows you to create your database schema as well and allows import from DBDesigner that I mentioned in the last post.