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,833 All time: 2,144 This week: 177Up
Version License Categories
compare_db 1.0.0GNU General Publi...Databases
Description 

Author

Michael Hauptmann

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: 402 Up16 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

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

  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  
Needed for Database Access