[FIXED] Compare two XML db schema in HeidiSQL

Issue

I exported two DB schema from server through phpmyadmin in XML format.
First XML schema is of testing database, and the second xml schema is of live database.
I want to compare these database schema, based theme comparison I would make the changes in live database.
How can I compare thsese XML database schemea in phpmyadmin or HeidiSQL?
I would appreciate any kind of help or support.

Solution

HeidiSQL can export structure and data, but there is no compare feature yet.

My tool of choice for comparing any type of file is BeyondCompare from https://www.scootersoftware.com . This is how it looks when you compare two .sql files (this can of course also be done with xml files):

Answered By - Anse