PHP Classes
elePHPant
Icontem

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    
Last Updated Ratings Unique User Downloads Download Rankings
2004-08-08 (11 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,712 All time: 2,200 This week: 683Up
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: 42
All time rank: 159435 in Spain Spain
Week rank: 1566 Up45 in Spain Spain Down

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,712
This week:0
All time:2,200
This week:683Up