Comparing Schemas

muzza4 posted 9 years ago in General
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.

ansgar posted 5 years ago
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.