current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
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.
up vote 1 down vote favorite

I saw some of the tutorials on how to migrate from sqlite to postgresql, but it is either for mac or it is for a new/fresh app. What if I already have an App with data sqlite in it. I am using rails 3.2.2 and windows 7. Anyone knows which is the best way to migrate sqlite to postgresql? Thanks

share|improve this question

1 Answer 1

up vote 0 down vote accepted

erm, if in development ,u re using sqlite and maybe you have to deploy to heroku, then it is just changing the gem for database. But the data will be blank, if you want to total migrate with data, I guess you have to dump the data and load it in postgresql

share|improve this answer
    
it is actually fine if the data will be blank. since my data is not that big. I can add it later. But the tables will be there right? So, do you mean I just have to add gem postresql? –  ishwr Apr 30 '13 at 3:19
    
ya, you can just insert to rake db:migrate and everything will be there. –  Nich Apr 30 '13 at 13:21
    
Sorry, but I did that all and there are my tables. But.. I can't create my posts anymore. Can't understand –  Arsenii Prohorchik Oct 21 '13 at 19:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.