You had requested for a visual tool to compare two instances of a table to spot differences. We heard that. We are delighted to introduce Visual Data Compare (VDC) in SQLyog 10.5. It lets you do exactly that and more. VDC allows you to compare two tables right next to each other making it easier to spot differences. It is a lot simpler than manually figuring it out all by yourselves.
VDC also doubles as an additional option for data sync. With VDC you will be able to compare differences visually and specify tables and rows that shall be synced as well as to decide in what direction to sync. It comes very handy when you want to copy lookup data from development databases to staging or production in cases where you for any reason don’t feel safe about having an automatic sync job running unattended in the background.
Visual Data Compare in action
What’s more in this release:
- Query Profiler is now available for Insert, Update and Delete statements for supported MySQL servers. MySQL 5.6.3 and above support this.
- Explain and Explain Extended for queries can now be executed from the Query Editor context menu.
- Few bug fixes. For detailed release notes, please refer here.
We are very excited about this release and hope that you will like it. We would love to hear your feedback.