Hi. 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
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---