Comparing Schemas

User, date Message
Written by muzza4
6 years ago
Category: General
51 posts since Mon, 04 Dec 06
Hi all,

How do people here (who use HeidiSQL in a dev/test/live set of environments) compare, say, the test schema to the live schema, to detect any differences between them?

I currently create a schema dump of both databases via HeidiSQL and compare using a text comparison tool (AptDiff), and then cut and paste out the relevant differences to create a report.

I'm after something a bit quicker and more reliable.

It would, of course, be great if this could be created as a HeidiSQL tool.

Written by ansgar
2 years ago
5023 posts since Fri, 07 Apr 06
One alternative is to use the "Export SQL" dialog in HeidiSQL, select Data: "INSERT IGNORE", so you only get new rows into the target tables. This however leaves rows on the target server which were deleted on the source server.

Please login to leave a reply, or register at first.