Copy sqlite database table to Postgres

Question

Is there a way to copy my local sqlite database table into my postgres database on production? I'm very new to Rails so any help is appreciated!

Trucker would seem to fit the bill for this.

PinnyM
– PinnyM

2013-04-10 02:47:27 +00:00
Commented Apr 10, 2013 at 2:47 — PinnyM
– PinnyM, Commented Apr 10, 2013 at 2:47

Blue Smith · Accepted Answer · 2013-04-10 03:26:44Z

1

You need a tool to export data from Sqlite and import it to Postgres. You can use https://github.com/ricardochimal/taps.

Here is a tutorial for this: http://railscasts.com/episodes/342-migrating-to-postgresql

answered Apr 10, 2013 at 3:26

Blue Smith

8,8402 gold badges30 silver badges33 bronze badges

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

Comments

lngs · Accepted Answer · 2013-04-10 04:18:51Z

1

You can use taps

notice

I saw you have a question about heroku a few day before. Does this question involved with Heroku? If so, you should not use sqlite locally and postgres remotely.

answered Apr 10, 2013 at 4:18

lngs

6981 gold badge8 silver badges17 bronze badges

Comments

Matt · Accepted Answer · 2013-04-10 10:01:42Z

0

Take a look at yaml_db for dumping and loading data. Easy to use.

answered Apr 10, 2013 at 10:01

Matt

211 bronze badge

Collectives™ on Stack Overflow

Copy sqlite database table to Postgres

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related