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 (12 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,738 All time: 2,185 This week: 936Up
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

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

Downloadcompare_db-2004-08-08.zip 29KB
Downloadcompare_db-2004-08-08.tar.gz 27KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,738
This week:0
All time:2,185
This week:936Up

  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.


  Related pages  
AdoDB
Needed for Database Access