dragonhong641016
2010-09-05 23:27 阅读 30

MySQL数据库同步

Is there any free MySQL synchronization tool out there?

I need to synchronize the database structure across servers. Data synchronization is not necessary (but is a plus).

It needs to be free (for non commercial use), not a free trial.

Edit: None of the answers so far has worked, were free, or a suitable to my needs.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

5条回答 默认 最新

  • 已采纳
    duan1982453 duan1982453 2010-10-17 23:13

    Toad® for MySQL can do both a "Schema Compare" as well as a "Data Compare" (and a lot more).

    By the way: the software is freeware - in case somebody asks.

    点赞 评论 复制链接分享
  • douzhengzuo7283 douzhengzuo7283 2010-09-06 00:00

    The only application i know that does this is Navicat for Mysql. It is fairly cheap, however it is not free :(

    点赞 评论 复制链接分享
  • dongniaocheng3773 dongniaocheng3773 2010-09-06 00:11

    try with mysql replication (part of the mysql solution) if still isnt a option. you can make a script which send a "show create table" for each table and store the structure and replicate it in the new server(s)

    点赞 评论 复制链接分享
  • duanlinma5885 duanlinma5885 2010-09-18 07:31

    There is a free tool that does this, it's called Mysql Workbench and they have a mac version. You need to reverse engineer your schema before synching..

    点赞 评论 复制链接分享
  • douwen5741 douwen5741 2010-09-18 07:42

    Try Daffodil Replicator, it is available in Open Source version as well. It is a Java tool for data synchronization, data migration, and data backup between various database servers.

    点赞 评论 复制链接分享

相关推荐