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!
Take the 2-minute tour
×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
|
|
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 |
|||||
|
|
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. |
|||
|
|
|
Take a look at yaml_db for dumping and loading data. Easy to use. |
|||
|
|
