dbcompare

Object Oriented PHP project which will compare two databases for changes

base

base file which is used to extend the classes for other scripts. which will manage the connect settings

dbcompare.php

compare tables

This file will list all the tables from db1 and db2 find out the changes of tables.

* which tables are missing in db1
* which tables are missing in db2
* create a string to dump a sql file
	* create table script
	* alter table script

dbcompare_compare_tables.php

/TODO/

compare data

This file will identify the key of the table, compare data of the two tables of two databases.identity the different columns and create a html file with checkboxes for the user to select which changes are the latest

dbcompare_compare_data.php

CHECKLIST

Stage 1

• list all the tables in db 1
• list all the tables in db 2
• find which tables are in db1 and NOT in db2
• find which tables are in db2 and NOT in db1
• create a text file to create missing tables in db1
• create a text file to create missing tables in db2
• loop through all the tables in db1
• compare the columns in each table
• identify the difference and create alter table queries Stage 2

---

• identify the key (which has the auto increment)
• if there.s no auto increment, it will identify the foreign keys
• get the key and query that row from the other db
• list all the changes in the row
• create a update query
• list all the missing records
• create a insert query Stage 3

---

• create backups of the database 1
• create backups of the database 2
• run the queries in dbs