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.
Support changing active result tab per shortcut, Alt+Left and Alt+Right. See http://www.heidisql.com/forum.php?t=7609
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.