I have a legacy db I need to write a project around. Can someone tell me how I can create my migrations from the table structure. Can this even be done, or must I create my migrations by hand? Thanks, Janna
JannaB wrote:> I have a legacy db I need to write a project around. Can someone tell > me how I can create my migrations from the table structure. Can this > even be done, or must I create my migrations by hand? Thanks, JannaIf you already have a legacy DB, why do you need migrations (aside from making future modifications)? -- Posted via http://www.ruby-forum.com/.
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> <title></title> </head> <body bgcolor="#ffffff" text="#000000"> JannaB wrote: <blockquote cite="mid:d0257662-863c-4875-bc8d-179acb495a9b-vBzl/e0nQ7qCoHMtaRxPRFYGCWtFR9XvxddQ6fo/n9Y@public.gmane.orgom" type="cite"> <pre wrap="">I have a legacy db I need to write a project around. Can someone tell me how I can create my migrations from the table structure. Can this even be done, or must I create my migrations by hand? Thanks, Janna </pre> </blockquote> The purpose of migrations is to create the database tables. They are not really needed for anything else. If you do not need them to recreate the tables you do not need the migrations.<br> <br> --~--~---------~--~----~------------~-------~--~----~<br> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. <br> To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <br> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org <br> For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en<br> -~----------~----~----~----~------~----~------~--~---<br> </body> </html> <br>
So, I guess the answer to my question -- can I create migrations from a given sql schema, is no? On Jun 5, 6:30 pm, Norm <normsche...-ihVZJaRskl1bRRN4PJnoQQ@public.gmane.org> wrote:> JannaB wrote:I have a legacy db I need to write a project around. Can someone tell me how I can create my migrations from the table structure. Can this even be done, or must I create my migrations by hand? Thanks, JannaThe purpose of migrations is to create the database tables. They are not really needed for anything else. If you do not need them to recreate the tables you do not need the migrations.
Configure this legacy database in your database.yml file and then: rake db:schema:dump The schema.rb file will contain the legacy database structure. - Maurício Linhares http://alinhavado.wordpress.com/ (pt-br) | http://codeshooter.wordpress.com/ (en) On Fri, Jun 5, 2009 at 11:25 PM, JannaB<mistressjanna-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote:> > So, I guess the answer to my question -- can I create migrations from > a given sql schema, is no? > > On Jun 5, 6:30 pm, Norm <normsche...-ihVZJaRskl1bRRN4PJnoQQ@public.gmane.org> wrote: >> JannaB wrote:I have a legacy db I need to write a project around. Can someone tell me how I can create my migrations from the table structure. Can this even be done, or must I create my migrations by hand? Thanks, JannaThe purpose of migrations is to create the database tables. They are not really needed for anything else. If you do not need them to recreate the tables you do not need the migrations. > > >
Thank you. I need this to move it from one db type to another. -Janna B. On Jun 5, 11:34 pm, Maurício Linhares <mauricio.linha...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:> Configure this legacy database in your database.yml file and then: > > rake db:schema:dump > > The schema.rb file will contain the legacy database structure. > > - > Maurício Linhareshttp://alinhavado.wordpress.com/(pt-br) |http://codeshooter.wordpress.com/(en) > > On Fri, Jun 5, 2009 at 11:25 PM, JannaB<mistressja...-PkbjNfxxIARBDgjK7y7TUQ@public.gmane.org> wrote: > > > So, I guess the answer to my question -- can I create migrations from > > a given sql schema, is no? > > > On Jun 5, 6:30 pm, Norm <normsche...-ihVZJaRskl1bRRN4PJnoQQ@public.gmane.org> wrote: > >> JannaB wrote:I have a legacy db I need to write a project around. Can someone tell me how I can create my migrations from the table structure. Can this even be done, or must I create my migrations by hand? Thanks, JannaThe purpose of migrations is to create the database tables. They are not really needed for anything else. If you do not need them to recreate the tables you do not need the migrations.