Migration from SQLite to PostgreSQL

Rails
1

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

2

Tue, Apr 30, 2013 at 3:21 AM, [email protected] wrote:

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

As far as I understood, you want to move your data from sqlite to
postgres… assuming you already created the db in postgres, maybe you
can
do a dump from sqlite and then use that dump in postgres

3

change in database.yml , use the syntax which is needed for PG , and
again
run command
bundle exec rake db:create
bundle exec rake db:migrate

4

On Tue, Apr 30, 2013 at 8:21 AM, [email protected] wrote:

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

look for the taps gem

best regards -botp