Hello, 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 database. 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 instead? Thanks.
on 2007-02-28 20:07