How to sync table schema?

Hi,

Form what I read on pt-table-sync documentation, it is not possible to sync table structure from server1 db.table to server2 db.table? Are there any work-arounds or alternatives to sync the table structure?

Thanks

Table schema is stored in INFORMATION_SCHEMA. You may have a home-grown script to query and compare the schema. Related tables are: tables, columns, key_column_usage, also triggers, routines, views if used.

Along with that one other option is mysqldbcompare from MySQL utilities. Check documentation here [url]http://dev.mysql.com/doc/mysql-utilities/1.3/en/mysqldbcompare.html[/url]