I have a DB2 schema with many ''views'' and table partitions defined in it. As per our new project requirement we have to support multiple databases (DB2,Oracle and MYSQL to be specific). The frontend application is implemented using Ruby on Rails. I am interested in exploring the possibility of using Rails Migrations to abstract out the schema to a DB independent layer. I could not find any reference material on the web on how I can apply Rails Migrations on a schema containing ''views'' and table partitions? Can anyone help me? Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Thu, Aug 28, 2008 at 12:14 PM, sinoda <sinoda007-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > I have a DB2 schema with many ''views'' and table partitions defined in > it. As per our new project requirement we have to support multiple > databases (DB2,Oracle and MYSQL to be specific). The frontend > application is implemented using Ruby on Rails. I am interested in > exploring the possibility of using Rails Migrations to abstract out > the schema to a DB independent layer. I could not find any reference > material on the web on how I can apply Rails Migrations on a schema > containing ''views'' and table partitions? Can anyone help me? Thanks in > advance.Sinoda, I have a project called rails_sql_views on github that might be helpful. It was extracted from the work I was doing on ActiveWarehouse and has been extended by others. At the moment it does not have an implementation for DB2, however you could implement the implementation. The repo is at: http://github.com/aeden/rails_sql_views/tree/master Sincerely, Anthony Eden --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Thank you Anthony. On Thu, Aug 28, 2008 at 9:48 AM, Anthony Eden <anthonyeden-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> > On Thu, Aug 28, 2008 at 12:14 PM, sinoda <sinoda007-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > > > I have a DB2 schema with many ''views'' and table partitions defined in > > it. As per our new project requirement we have to support multiple > > databases (DB2,Oracle and MYSQL to be specific). The frontend > > application is implemented using Ruby on Rails. I am interested in > > exploring the possibility of using Rails Migrations to abstract out > > the schema to a DB independent layer. I could not find any reference > > material on the web on how I can apply Rails Migrations on a schema > > containing ''views'' and table partitions? Can anyone help me? Thanks in > > advance. > > Sinoda, > > I have a project called rails_sql_views on github that might be > helpful. It was extracted from the work I was doing on ActiveWarehouse > and has been extended by others. At the moment it does not have an > implementation for DB2, however you could implement the > implementation. The repo is at: > http://github.com/aeden/rails_sql_views/tree/master > > Sincerely, > Anthony Eden > > > >--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---