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
[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to