Comparing Schemas

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.

Cheers
Muzza

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.

Since this question is very old and it still shows up very high in a google search i wonder if heidi has added some features to compare two schemas?

Not really for comparing. As written above you can export one schema on top of another one.

I found myself comparing two SQL exports through BeyondCompare, a nice diff tool.

Apart from that, several years ago I started to work on a synchronization feature in HeidiSQL, which is still in the code but unfinished and inaccessible for users. I just made it available in my local build: