CODEWITHSUNDEEP
mysqldatabasephpmyadminschemaheidisql
ahm_bramhasami
ahm_bramhasami

Reputation: 15

Compare two XML db schema in HeidiSQL

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.

Upvotes: 0

Views: 914

Answers (1)

Anse
Anse

Reputation: 1660

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):

enter image description here

Upvotes: 1

Related Questions