| John: | It's crazy! How am I going to compare 150 different MySQL tables for changes ? |
| Adam: | Why are you comparing them for ? |
| John: | We need to update our live database for the latest changes from our development databases. Problem is, we can't remember what was modified since there were so many different tables and columns being added and removed! |
| Adam: | Ah, you need to compare schema differences between all the tables from two different databases ? |
| John: | That's right, Adam. We need to synchronize the changes while maintaining the live site data. If we do not ensure the schemas are identical, we're afraid the new codebase would cause errors due to an unsupported database structure. |
| Adam: | You've come to the right place. Our CompareSQLTables tool below will perform a visual comparison that even a dumba@s can understand. It works with MySQL and it's a PHP script that can be installed under 3 minutes. |
| John: | Wow. Just what I need. What else does it do ? |
| Adam: | CompareSQLTables will compare tables from two databases, list missing tables, compare columns between two similar named tables from two databases, list missing columns, and for every column of every table, it will display the difference in the attributes for the column, such as NULL values, primary keys, indexes, signed/unsigned types and more. Even better, any differences from the lowest level such as attribute differences, are cascaded upwards to the column view, and further cascaded to the table view. This allows anyone at a single glance to zoom in further into the tables that show differences in structure. It does not take into account difference in data, as this is a database schema comparison tool and not a data comparison tool. |
| John: | Great! How do I set it up ? |
| Adam: | Very simple. CompareSQLTables consists of just 1 php file. Simply edit the header of that file to store the connection values of 2 different database connections and load that file from the web server. Please view the demonstration above to see a fully functional system at work. |
| John: | Thanks Adam. It looks so easy to understand. Let me give it a try. |