Login   Register  
PHP Classes
elePHPant
Icontem

DBSync: Synchronize the schema of MySQL databases

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of Diogo Resende
Name: Diogo Resende <contact>
Classes: 10 packages by
Country: Portugal Portugal
Age: 31
All time rank: 252 in Portugal Portugal
Week rank: 166 Down2 in Portugal Portugal Equal
Innovation award
Innovation award
Nominee: 4x

Winner: 2x


  Detailed description   Download Download .zip .tar.gz  
This class provides a way to synchronize the schema of one or more databases from the schema of a master database.

Currently, the class only synchronizes the database schema, not data in the database tables.

For now it supports MySQL databases but the schema manipulation functions are implemented in a separate driver class. Therefore, support for other types of databases can be implemented by writing new driver classes.

  Classes of Diogo Resende  >  DBSync  >  Download Download .zip .tar.gz  >  Support forum Support forum (4)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: DBSync
Base name: dbsync
Description: Synchronize the schema of MySQL databases
Version: -
PHP version: -
License: GNU General Public License (GPL)
All time users: 2987 users
All time rank: 1123
Week users: 0 users
Week rank: 1372 Equal
 
  Groups   Rate classes User ratings   Trackback   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  Innovation Award  
PHP Programming Innovation award winner
June 2005
Winner


Prize: One book of choice by O'Reilly
Sometimes it is necessary to alter the schema of a database to introduce new features or change the current features of an application.

Usually the new or changed application features are tested first in a development environment.

When the new developments are ready to go in production, it is necessary to update the schema of the database in production to have the same structure of the database in the development environment.

This class provides a solution for this problem by comparing the schemas of the database in the development and production environments and performing the necessary alterations to synchronize the schemas.

Manuel Lemos

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (82%) Good (85%) Good (80%) Good (82%) - - Sufficient (66%) 421
Month: Not yet rated by the users

  Pages that reference this package  
SVN and MySQL Schema Synchronization
When I started to work in a virtual team comprising of 6 developers , I felt that the most time consuming task was syncing the database changes amongst team members...

Latest pages that reference packages Latest pages that reference packages


  Applications that use this package  
No pages of applications that use this class were specified.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file class.dbsync.mysql.php Class MySQL Sync Driver
Plain text file class.dbsync.php Class Main Class
Accessible without login Plain text file README Doc. Read this!
Accessible without login Image file reload.png Icon Image on test.php
Accessible without login Plain text file test.php Example Test script

Download Download all files: dbsync.tar.gz dbsync.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.