[ANN] MysqlTableSyncer 0.2

[Roger Pack]

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

 

[Michael Guterl]

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.

It would be great if you could package this as a gem.

This sounds really useful.

Thanks!
Michael Guterl

 

[Bill Walton]

Hi Roger,

Roger Pack 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

 

[Roger Pack]

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

 

[Michael Guterl]

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!

You rock!

Thanks!
Michael Guterl

 

[Pablo Q.]

[Note: parts of this message were removed to make it a legal post.]

really cool. Waiting for oracle version...