如何比较MySQL数据库架构

本文介绍了如何比较MySQL数据库架构的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在寻找一种工具，可以比较MySQL数据库的模式. 哪一个是最好的工具?

I am looking for a tool that will allow me to compare schemas of MySQL databases. Which is the best tool to do that?

推荐答案

Navicat可以为您做到这一点.它还将在两个mysql数据库实例之间同步模式和/或数据.我过去曾经成功使用过它.

Navicat is able to do that for you. It will also synchronize schema and/or data between two mysql database instances. I've used it with success in the past.

www.navicat/en/products/navicat_mysql/mysql_overview.html

这里有数据和结构同步工具的屏幕截图:

There is a screenshot of the data and structure synchronization tool here:

www.navicat/en/products/navicat_mysql/mysql_detail_mac.html#7