Forum: Ruby on Rails using activerecord to copy records from one database to anot

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
1ca94522746f7fcf4eea3d3f418d3a66?d=identicon&s=25 Dan (Guest)
on 2007-02-28 20:07
(Received via mailing list)

Our DBA accidentally restored a database resulting in a loss of all
data from the weekend.  The problem is that it was discovered after a
day's worth of data entry, resulting in the same record keys
identifying different records.

The data is quite complex with a larger number of relationships.  I
have been thinking about using ActiveRecord to pull the missing days
worth of data out of a back up and insert it into the production

My concern is that all of the keys would need to be cleared from
objects retrieved from the backup before they were inserted into the
production database.

Is there an easy way to do this?  Think I should just use raw SQL

This topic is locked and can not be replied to.