Hi, I want to add data from a fixture file to a table inside a migration. I've saved the file in db/migrate/fixtures/countries.yml I guess I could just open the file, read the entries, and add them to the database using AR, but I'm hoping I can use Rails for all that. Also, if I have a file, say, with 200,000+ records, what would be the best method (performance-wise) to go about this? I was thinking splitting the data on multiple files, each about 10,000 records or so... what do you think? I don't want to use SQL for this, to avoid problems between different databases. Thanks a lot! Ivan V.
on 2006-04-21 20:21