I'm wondering if anyone has had experience importing a large amount of data into their heroku database and how they went about doing it. I'm staring down about 3-4M rows of (static) data that I'd like to get into our DB on Heroku.
If I had my own database locally I would probably use the COPY command as it is blazing fast. Inserting a row at a time from ruby code or going through an exposed API is looking like it will take multiple days to do (without spending extra money to crank up more dynos and buy a larger DB option) Another option I thought of would be to figure out a way to load the data in a local db then dump only that table and restore it into the heroku db as a partial backup, but I didn't see any facility for that. Has anyone done anything like this or think of a good way for doing it? Thanks, Zach -- You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.
