PHP Classes

Compare DB: Compare and synchronize two databases

Recommend this page to a friend!
  Info   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,837 This week: 1All time: 2,142 This week: 560Up
Version License Categories
compare_db 1.0.0GNU General Publi...Databases
Description 

Author

This package is meant to compare two databases and generate the necessary SQL commands to alter one to have the same structure and data of the other.

On the same page of the example script you will be able to click to execute any single command the script proposes.

Picture of Michael Hauptmann
Name: Michael Hauptmann <contact>
Classes: 1 package by
Country: Spain Spain
Age: 50
All time rank: 159734 in Spain Spain
Week rank: 411 Up13 in Spain Spain Up

Details

$Id: readme.txt,v 1.1 2004/08/07 15:00:45 miguel Exp $ A class to compare 2 DBs. It outputs the changes to be done and let you execute the SQL-Queries 1 by 1 from the same page. Requires AdoDB USAGE Open the file compare.php. Replace the access data for the 2 DBs to be compared. DB1 is the database you'd like to update. DB2 is the reference DB. Replace the path to your AdbDb installation directory. Open up compare.php. TODO Need to do some more error-checking. NOTE The class is still in BETA... be careful what you are doing!!

  Files folder image Files  
File Role Description
Accessible without login Plain text file compare.php Example The file to access from the browser
Plain text file compareDb.class.php Class Holds the class which handles the data
Accessible without login Plain text file mysql_charsets.lib.php Aux. Needed library class (borrowed from phpMyAdmin)
Accessible without login Plain text file readme.txt Doc. Readme file
Accessible without login Plain text file sqlparser.data.php Aux. Needed library (borrowed from phpMyAdmin)
Accessible without login Plain text file sqlparser.lib.php Aux. Needed library (borrowed from phpMyAdmin)
Accessible without login Plain text file string.lib.php Aux. Needed library (borrowed from phpMyAdmin)
Accessible without login Plain text file template.css Data Styles for the output
Accessible without login Plain text file template.php Data The template file for the output

 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,837
This week:1
All time:2,142
This week:560Up