CODEWITHSUNDEEP
ruby-on-railssqlitepostgresql
Sara
Sara

Reputation: 2769

Copy sqlite database table to Postgres

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!

Upvotes: 1

Views: 1168

Answers (3)

Matt
Matt

Reputation: 21

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

Upvotes: 0

lngs
lngs

Reputation: 698

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.

Upvotes: 1

Blue Smith
Blue Smith

Reputation: 8820

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

Upvotes: 1

Related Questions