PHP Classes

Database structure synchronizer: Compare MySQL databases to synchronize structures

Recommend this page to a friend!
     
  Info   Screenshots   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 62%Total: 3,141 All time: 1,149 This week: 54Up
Version License PHP version Categories
db_struct_sync 1.0.0GNU General Publi...4.0Databases, Text processing
Description 

Author

shadower

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: 41
All time rank: 102418 in Ukraine Ukraine
Week rank: 195 Up4 in Ukraine Ukraine Up

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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloaddb_struct_sync-2011-04-18.zip 190KB
Downloaddb_struct_sync-2011-04-18.tar.gz 190KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:3,141
This week:0
All time:1,149
This week:54Up
User Ratings User Comments (1)
 All time
Utility:91%StarStarStarStarStar
Consistency:87%StarStarStarStarStar
Documentation:83%StarStarStarStarStar
Examples:-
Tests:-
Videos:-
Overall:62%StarStarStarStar
Rank:879
 
Good script saved me loads of time.
10 years ago (Patrick McCarthy)		67%StarStarStarStar
 

  Applications that use this package  
fresh version at gihub
online demo

Add link image If you know an application of this package, send a message to the author to add a link here.


  Pages that reference this package  
Database structure synchronizer es un script PHP que nos viene servido en forma de clase y es una pequeña joya imperdible, sobre todo si desarrollamos en grupos de trabajo poco organizados:...
Interesante script que permite dados dos estructuras del MySQL, obtenidas por ejemplo usando un mysqldump, ver que diferencias hay entre ambos y devuelve las queries necesarias para igualar las dos estrucuras...

Latest pages that reference packages Latest pages that reference packages