Hi all, Is there any gem to copy data from mysql to postgres ? I search lot but i didn''t get any thing . Thanks Fahim -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/a7BZJWbsdq8J. For more options, visit https://groups.google.com/groups/opt_out.
On Mon, Jan 14, 2013 at 6:06 AM, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Is there any gem to copy data from mysql to postgres ? > I search lot but i didn''t get any thing .You''re gonna have to figure that one out yourself by using 2 models and some clever trickery, or you might be able to dump the data and import into postgres if it''s generic enough with little effort but I would much rather go the 2 model route even if it takes far more time. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
Thanks lot for reply. Few months ago i have studied about one gem which do this work, but i forget the name. Did any one know about this ? On Monday, January 14, 2013 5:42:48 PM UTC+5:30, Jordon Bedwell wrote:> > On Mon, Jan 14, 2013 at 6:06 AM, Fahim Patel <paf...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org<javascript:>> > wrote: > > Is there any gem to copy data from mysql to postgres ? > > I search lot but i didn''t get any thing . > > You''re gonna have to figure that one out yourself by using 2 models > and some clever trickery, or you might be able to dump the data and > import into postgres if it''s generic enough with little effort but I > would much rather go the 2 model route even if it takes far more time. >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/6HThJnhHN9sJ. For more options, visit https://groups.google.com/groups/opt_out.
On 14 January 2013 12:06, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > Hi all, > > Is there any gem to copy data from mysql to postgres ? > I search lot but i didn''t get any thing .http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL describes how to do a dump from mysql and restore to postgres but I don''t see any advantage of using a gem over that technique. Colin -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
use gem taps 2013/1/14 Colin Law <clanlaw-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org>> On 14 January 2013 12:06, Fahim Patel <pafahim-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > Hi all, > > > > Is there any gem to copy data from mysql to postgres ? > > I search lot but i didn''t get any thing . > > http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL describes > how to do a dump from mysql and restore to postgres but I don''t see > any advantage of using a gem over that technique. > > Colin > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit https://groups.google.com/groups/opt_out. > > >-- Rodrigo Mendonça (62) 8567-3142 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
Thanks lot for reply. Fahim On Monday, January 14, 2013 6:19:17 PM UTC+5:30, Rodrigo Mendonça wrote:> > use gem taps > > 2013/1/14 Colin Law <cla...-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org <javascript:>> > >> On 14 January 2013 12:06, Fahim Patel <paf...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org <javascript:>> >> wrote: >> > >> > Hi all, >> > >> > Is there any gem to copy data from mysql to postgres ? >> > I search lot but i didn''t get any thing . >> >> http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL describes >> how to do a dump from mysql and restore to postgres but I don''t see >> any advantage of using a gem over that technique. >> >> Colin >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Ruby on Rails: Talk" group. >> To post to this group, send email to rubyonra...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<javascript:> >> . >> To unsubscribe from this group, send email to >> rubyonrails-ta...-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > -- > Rodrigo Mendonça > (62) 8567-3142-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/us15OehxhyAJ. For more options, visit https://groups.google.com/groups/opt_out.
I really like yaml_db for this. I have only used it for SQLite to MySQL and MySQL to MySQL, but it works smoothly and quickly, and in my case, did not flinch at 2M records in a table. Walter On Jan 14, 2013, at 7:06 AM, Fahim Patel wrote:> > Hi all, > > Is there any gem to copy data from mysql to postgres ? > I search lot but i didn''t get any thing . > > Thanks > Fahim > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/a7BZJWbsdq8J. > 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 post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit https://groups.google.com/groups/opt_out.
I would like to add: if you have some custom mapping between the models, you could write a simple rake task. Example: http://myutil.com/2008/8/31/rake-task-transfer-rails-database-mysql-to-postgres Regards, Anton -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/94mbCFp7J0MJ. For more options, visit https://groups.google.com/groups/opt_out.