How to copy my local db to heroku?

Question

I'm working on a simple Rails (activeRecord based) application, and i'm testing in locally.

Now it's time to move online, but... do i need to insert all the records again in the app's db? I hope not!

Do you know a if is it possible to make a copy of my entire local db and import it in heroku?

Thanks!

sqlite3. Heroku is a great ruby on rails hosting service! I suggest you to try it — Abramodj
– Abramodj, Commented Apr 25, 2011 at 18:13

John Beynon · Accepted Answer · 2011-04-25 19:43:55Z

12

erm, using the Heroku CLI

heroku db:push

job done, built into Heroku - will magically transpose your local DB whether it be sqlite, mysql, postgres to Heroku's shared postgresql db.

answered Apr 25, 2011 at 19:43

John Beynon

37.5k8 gold badges92 silver badges97 bronze badges

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

3 Comments

Worked just fine for me. You have to have the taps gem installed.

What if the remote db is not empty? ` push from LOCAL_SOURCE_DATABASE to REMOTE_TARGET_DATABASE REMOTE_TARGET_DATABASE must be empty.

fl00r · Accepted Answer · 2011-04-25 17:43:28Z

3

Try yaml_db gem

https://github.com/ludicast/yaml_db

answered Apr 25, 2011 at 17:43

fl00r

83.7k33 gold badges222 silver badges239 bronze badges

and totally unnecessary when it comes to Heroku.