Alec Taylor
2011-Nov-30 05:53 UTC
MS Access integration with Rails through conversion to (Postgres or MySQL) xor direct interaction
Good afternoon, Is there a Ruby ORM gem which integrates with MS Access? Alternatively how would I convert one to PostgreSQL or MySQL then interpret it into ORM syntax for use in Ruby? Thanks for all suggestions, Alec Taylor -- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
wilson
2011-Nov-30 15:52 UTC
Re: MS Access integration with Rails through conversion to (Postgres or MySQL) xor direct interaction
I think it is not a good idea to use Access as a datebase. You could use EMS SQL Management Studio for PostgreSQL to export your data from access to PostgreSql and then adopt ActiveRecord in your Ruby project. But you have to adapt the table names and structure as the ActiveRecord convention or customize the models (http:// 2dconcept.com/articles/2-rails-legacy-db-activerecord-conventions). On 30 nov, 03:53, Alec Taylor <alec.tayl...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Good afternoon, > > Is there a Ruby ORM gem which integrates with MS Access? > > Alternatively how would I convert one to PostgreSQL or MySQL then > interpret it into ORM syntax for use in Ruby? > > Thanks for all suggestions, > > Alec Taylor-- 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 this group at http://groups.google.com/group/rubyonrails-talk?hl=en.