Comparing Schemas
| User, date | Message |
|---|---|
|
Written by muzza4
5 years ago Category: General 50 posts since Mon, 04 Dec 06 |
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 |
|
Written by ansgar
11 months ago 3973 posts since Fri, 07 Apr 06 |
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. |