mysqldatabasephpmyadminschemaheidisql
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.
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):
- MySQL or MariaDB - how to instantiate user @variables?
- MySQLConnector c# update MySqlCommand parameters
- INSERT INTO after WITH statement in MySQL
- ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
- Connect to mysql in a docker container from the host
- Executing SQL scripts on docker container
- XAMPP - Error: MySQL shutdown unexpectedly
- Undefined Module Mysl - Ballerina
- DBeaver error resolving maven dependencies
- ERROR - Must Declare Scalar Variable - C#
- Cannot delete or update a parent row: a foreign key constraint fails. Foreign keys exist though
- MySQL: IF EXISTS ... TRUNCATE
- mysql COUNT and Sum with join 2 tables
- Install Navicat on Linux Ubuntu 12.04
- How do I set MySQL temporarily to read-only through the command line?
- How to increment column values with CodeIgniter's update_batch()
- str_to_date is showing NULL when date is available
- Can I use a variable from the GET_ method to fetch MySQL data?
- select ... where id = any value. is it possible?
- Data truncated for column?
- Unable to install MySQL on Windows 10 - Installer hangs indefinitely
- Why can't I just use "HAVING" clause all the time instead of "WHERE"? It works the same basically if you use it before/without "GROUP BY"
- MySQL Workbench: Connecting to database automatically on the startup
- Select rows for a specific date using TIMESTAMP datatype
- GoLang How to load nested objects using GORM
- What COLLATE should i set to use all kind of possible languages?
- MYSQL - SELECT NULL otherwise latest DATE per group
- How do I set up replication from MySQL to MongoDB?
- NULL when value not found using substring_index in MYSQL
- How to convert an entire MySQL database characterset and collation to UTF-8?