List:Community« Previous MessageNext Message »
From:Arjen Lentz Date:April 6 2014 8:50pm
Subject:RE: Database synchronization
View as plain text  
Hi

The table-checksum and table-sync parts of Percona Toolkit can do some of this.

They're usually used for verifying and fixing replication environments but they can output changes to a file.
Note that they mainly deal with data differences, which your devs may still find useful as some parts of an upgraded environment would need updating. 

You can identify schema changes using mysqldump --no-data and diff, and with some scripting you could even automate that. Quite possibly one of the Percona tools can help you with that also. I'd need to check.

If you need any assistance with this, contact details below.

Regards,  Arjen.
Exec.Director Open Query Pty Ltd
openquery.com.au
Thread
Database synchronizationWeydson Lima3 Apr 2014
  • Re: Database synchronizationshayne.alone@gmail.com5 Apr 2014
    • RE: Database synchronizationWeydson Lima6 Apr 2014
RE: Database synchronizationArjen Lentz6 Apr 2014