Rails: upload local database to remote

Question

In my Rails App, I scraped many data from other websites, and it's all on my local development database. Now, I want to deploy my website to Heroku, and I want to upload the local data as well, so I don't need to scrape those data again. How can I do it?

I think I can just convert the local data(just a few models) into yml, or csv, and then write a rake task to read from those file.

I'm wondering if there are better approaches.

Have you tried `pg:push` https://devcenter.heroku.com/articles/heroku-postgresql#pg-push ? — Nitish Parkar, May 22 '15 at 05:01
@cqcn1991 Please do consider accepting the answer if it has helped you in solving your question . — , May 22 '15 at 11:04
@GhostBuster I'm about to, but now I'm struggling with other code problem, I'll accept once I test that gem. — ZK Zhao, May 22 '15 at 11:26

score 2 · Accepted Answer · answered May 22 '15 at 06:57

2

I think what you are looking for is this

Allows you to take backup of your db using simple commands and then you just need to restore it on the live database . Quite easy .

answered May 22 '15 at 06:57

Caffeine Coder

1,869
1
17
35

Rails: upload local database to remote

1 Answers1