Comparing Schemas

muzza4's profile image muzza4 posted 16 years ago in General Permalink
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's profile image ansgar posted 12 years ago Permalink
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.
surfmuggle's profile image surfmuggle posted 5 years ago Permalink

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?

ansgar's profile image ansgar posted 5 years ago Permalink

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:


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