Alex Rivera | Logout

How to compare MySQL database schemas

Asked 2009-05-18T08:30:27.487
10

I am looking for a tool that will allow me to compare schemas of MySQL databases.
Which is the best tool to do that?

Edit
Report

2 Answers

8

Navicat is able to do that for you. It will also synchronize schema and/or data between two mysql database instances. I've used it with success in the past.

Link

There is a screenshot of the data and structure synchronization tool here:

http://www.navicat.com/en/products/navicat_mysql/mysql_detail_mac.html#7

answered 2009-05-18T08:40:25.127
5

I use SQLyog:

http://www.webyog.com/en/

It isn't free but is a very good tool and has saved the cost of it's license many many times over. I'm in no way affiliated with the company, just someone who has used a number of MySQL tools.

Free trial(30-day) available from here.

enter image description here

answered 2009-05-18T09:39:14.117

Your Answer