LMSouq
database Open

Compare two MySQL databases

VI
Vincent Ramdhanie
1 month ago
3 views
Problem Description
I'm currently developing an application using a MySQL database. The database-structure is still in flux and changes while development progresses (I change my local copy, leaving the one on the test-server alone). Is there a way to compare the two instances of the database to see if there were any changes? While currently simply discarding the previous test server database is fine, as testing starts entering test data it could get a bit tricky. The same though more so will happen again later in production... Is there an easy way to incrementally make changes to the production database, preferably by automatically creating a script to modify it? --- Tools mentioned in the answers: - [Red-Gate's MySQL Schema & Data Compare](https://www.red-gate.com/products/mysql/mysql-compare/) (Commercial) - [Maatkit (now Percona)](https://launchpad.net/percona-toolkit) - [liquibase](http://www.liquibase.org) - [Toad](http://www.quest.com/toad-for-mysql/) - [Nob Hill Database Compare](http://nobhillsoft.com/NHDBCompare.aspx) (Commercial) - [MySQL Diff](http://adamspiers.org/computing/mysqldiff/) - [SQL EDT](http://www.sqledt.com) (Commercial)

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base