I have a Rails application in which I use MySQL on the backend. My
client has a SQL Server database where they store customer information
via a third party program. I don’t want to touch that database (other
than reading) but I want to copy it’s contents from two tables out to
the MySQL database. In fact, I’ll have a job run on a weekly basis to
keep the two databases in-sync (with updates for existing changed
records and inserts for new records). The amount of changes are very
small on a weekly basis. My issue is I’d like to use ActiveRecord to
connect to the SQL Server grab the data and then write the results from
that back to the MySQL database. This doesn’t seem possible from what
I’ve read regarding ActiveRecord so I need some advice here please on
how best to do this.
Thanks for any help.