Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Comparing Schemas

muzza4's profile image muzza4 posted 11 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.

Cheers
Muzza
ansgar's profile image ansgar posted 7 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.
Code modification/commit from ansgar.becker, 6 years ago, revision 4734
Support changing active result tab per shortcut, Alt+Left and Alt+Right. See http://www.heidisql.com/forum.php?t=7609
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
surfmuggle's profile image surfmuggle posted 1 month 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 1 month 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:

Description

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