PHP Classes

Database structure synchronizer: Compare MySQL databases to synchronize structures

Recommend this page to a friend!
  Info   Screenshots Screenshots   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (5)   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 62%Total: 3,137 This week: 2All time: 1,151 This week: 96Up
Version License PHP version Categories
db_struct_sync 1.0.0GNU General Publi...4.0Databases, Text processing
Description 

Author

This class can be used to compare two MySQL database table structures to generate SQL statements to update one to become another.

It can compare the table creation SQL statements of two MySQL databases as outputted for instance by the mysqldump command.

The class determines what changed from one database to the other and generates schema alteration SQL statements to create, drop and alter tables that should be applied to one database to make it have the same schema of the other.

Picture of shadower
Name: shadower <contact>
Classes: 1 package by
Country: Ukraine Ukraine
Age: 40
All time rank: 102418 in Ukraine Ukraine
Week rank: 106 Up1 in Ukraine Ukraine Up

Screenshots  
  • syncDemo.jpg
  Files folder image Files  
File Role Description
Plain text file dbStruct.php Class Class source
Plain text file dbStruct_readme.txt Doc. short documentation

 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,137
This week:2
All time:1,151
This week:96Up
User Ratings User Comments (1)
 All time
Utility:91%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:83%StarStarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:62%StarStarStarStar
Rank:868
 
Good script saved me loads of time.
9 years ago (Patrick McCarthy)
67%StarStarStarStar