Load legacy sqlite3 db into postgresql on Heroku

Question

I have an sqlite3 database with data I want to load into my Heroku app's postgres db.

What's the best way to do this?

I was going to try exporting the records (it's a single table) to a yaml file and then uploading that file to heroku and initializing new records from it, but I ran into encoding issues. Those problems aside, is that a good approach? What's a better way of solving that problem?

Max Dunn · Accepted Answer · 2012-10-10 23:49:57Z

2

A good way to transfer data to a different type of database is to use the yaml_db gem. After adding it to your Gemfile and running bundle, you can then extract the data locally using:

rake db:data:dump

This will produce a db/data.yml file. Check this into Git, push to Heroku, then run:

heroku run console
rake db:data:load

That should do it.

answered Oct 10, 2012 at 23:49

Max Dunn

1,2449 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Load legacy sqlite3 db into postgresql on Heroku

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related