Sync with legacy database

Rails
1

Hi all,

I want to synchronise contacts in a rails DB with a legacy MySQL table
that is in use with a Perl CGI app. A straight import isn’t really good
enough, it needs to be something that can be run every so often and
import new contacts, ideally changed contacts as well.

I’m new to Rails - is there any infrastructure for this task or do I
need to code it from scratch? Should I even be looking to do this in
Rails?

Antony G. | Open Source Consultancy
Wayforth | Software Development
020 7247 1011 | Website Design
http://www.wayforth.co.uk | Peace-of-mind Support

2

Antony G. wrote:

Hi all,

I want to synchronise contacts in a rails DB with a legacy MySQL table
that is in use with a Perl CGI app. A straight import isn’t really good
enough, it needs to be something that can be run every so often and
import new contacts, ideally changed contacts as well.

I’m new to Rails - is there any infrastructure for this task or do I
need to code it from scratch? Should I even be looking to do this in Rails?

Use Observer
(http://api.rubyonrails.org/classes/ActiveRecord/Observer.html) for
Rails DB to legacy DB sync. For the other way round you have to
implement
something in the Perl CGI app.

–
Sava C.