PHP Classes

Compare DB: Compare and synchronize two databases

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,839 All time: 2,141 This week: 57Up
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

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 (9)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
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,839
This week:0
All time:2,141
This week:57Up

  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