# How to sync table schema?

**URL:** <https://forums.percona.com/t/how-to-sync-table-schema/3924>\
**Category:** Percona Toolkit\
**Created:** [December 2, 2014, 9:07am UTC](https://forums.percona.com/t/how-to-sync-table-schema/3924 "2014-12-02T09:07:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![alien](https://avatars.discourse-cdn.com/v4/letter/a/57b2e6/32.png) [@alien](https://forums.percona.com/u/alien)\
**Post date:** [December 2, 2014, 9:07am UTC](https://forums.percona.com/t/how-to-sync-table-schema/3924/1 "2014-12-02T09:07:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![psong](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/psong/32/16894_2.png) [@psong](https://forums.percona.com/u/psong)\
**Post date:** [December 4, 2014, 1:27am UTC](https://forums.percona.com/t/how-to-sync-table-schema/3924/2 "2014-12-04T01:27:59Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [December 5, 2014, 8:02am UTC](https://forums.percona.com/t/how-to-sync-table-schema/3924/3 "2014-12-05T08:02:29Z")

</div>

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]](http://dev.mysql.com/doc/mysql-utilities/1.3/en/mysqldbcompare.html%5B/url%5D)