From: D. Dante Lorenso (dantelarkspark.com)
Date: Mon Oct 06 2008 - 11:39:26 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Uma Bhat wrote:
> We are in progress of *optimizing* and designing the existing mysql database
> enviromnent on *linux*. And need help in comaparing schema of 50
> databases from the same mysql instance.

If you can afford to spend a few dollars to get the right tool, you want
to get DB Comparer for MySQL from the folks at EMS:

     http://www.sqlmanager.net/en/products/mysql/dbcomparer

This tool will compare the schemas of 2 MySQL Databases and allow you to
selectively choose which changes to make in order to synch to the master
or the target DB.

I've been using the PostgreSQL version of this tool for many years and
just recently started using their MySQL one.

-- Dante

----------
D. Dante Lorenso
dantelarkspark.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]