dil.takodil-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org
2013-Apr-30 08:21 UTC
Migration from SQLite to PostgreSQL
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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/mMd3RQo6HVsJ. For more options, visit https://groups.google.com/groups/opt_out.
Tue, Apr 30, 2013 at 3:21 AM, <dil.takodil-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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? ThanksAs 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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
On Tue, Apr 30, 2013 at 8:21 AM, <dil.takodil-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
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 On Tue, Apr 30, 2013 at 4:25 PM, botp <botpena-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> On Tue, Apr 30, 2013 at 8:21 AM, <dil.takodil-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit https://groups.google.com/groups/opt_out. > > >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.