Heroku: Dump Postgres database into local SQLite3 database for Rails project

Question

Is there way to dump heroku postgres database and import the data into my local SQLite database?

I tried using https://github.com/ludicast/yaml_db and heroku db:pull with no success. I am developing on Windows 7.

Answer 1

Please read through

https://devcenter.heroku.com/articles/heroku-postgres-import-export

and follow those to export.

Though the above link can be used to export alone, it does not have solution for the entire process. So you can look on the similar question and its solution

Copy a heroku postgres db to a local sqlite db