Released a script recently to sync the contents of tables between two
different mysql databases.
The need for this is mostly as a faster, open source replacement to
Navicat [to those who have used it] or SQLyog – since you can sync on
the command line it’s faster 
Syntax:
ruby syncer.rb --from=database1 --to=database2 --tables=table_1,table_2
It will show you a diff of the tables and/or optionally sync them so
that the contents of database2’s table_1 and table_2 will match
database1
New in version 0.2:
Now it can do a limited structure sync of different tables, as well, and
perform an “entire database” sync.
See
http://code.google.com/p/ruby-roger-useful-functions/wiki/MysqlTableSyncer
for more details.
Feedback welcome.
Thanks!
-=Roger
On Mon, Sep 22, 2008 at 12:59 PM, Roger P. [email protected]
wrote:
It will show you a diff of the tables and/or optionally sync them so
It would be great if you could package this as a gem.
This sounds really useful.
Thanks!
Michael G.
Hi Roger,
Roger P. wrote:
Released a script recently to sync the contents of tables between two
different mysql databases.
Nice! I took a look and posted a little feedback at the link provided.
Looking forward to trying it out!
Best regards,
Bill
Michael G. wrote:
It will show you a diff of the tables and/or optionally sync them so
It would be great if you could package this as a gem.
All righty released it as a gem.
gem install table_syncer
with updated instructions:
http://code.google.com/p/ruby-roger-useful-functions/wiki/TableSyncer
Enjoy!
-=R
really cool. Waiting for oracle version…
2008/9/30 Michael G. [email protected]