# Creating migrations **URL:** \ **Category:** Rails\ **Created:** [June 6, 2009, 12:01am UTC](https://www.ruby-forum.com/t/creating-migrations/169625 "2009-06-06T00:01:49Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![JannaB](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/df788c/32.png) [@JannaB](https://www.ruby-forum.com/u/JannaB)\ **Post date:** [June 6, 2009, 12:01am UTC](https://www.ruby-forum.com/t/creating-migrations/169625/1 "2009-06-06T00:01:49Z")
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 ---
**Author:** ![JannaB](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/df788c/32.png) [@JannaB](https://www.ruby-forum.com/u/JannaB)\ **Post date:** [June 6, 2009, 12:16am UTC](https://www.ruby-forum.com/t/creating-migrations/169625/2 "2009-06-06T00:16:37Z")
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, Janna If you already have a legacy DB, why do you need migrations (aside from making future modifications)? ---
**Author:** ![JannaB](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/df788c/32.png) [@JannaB](https://www.ruby-forum.com/u/JannaB)\ **Post date:** [June 6, 2009, 12:31am UTC](https://www.ruby-forum.com/t/creating-migrations/169625/3 "2009-06-06T00:31:50Z")
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, Janna > ``` 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. --~--~---------~--~----~------------~-------~--~----~ 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 removed\_email\_address@domain.invalid To unsubscribe from this group, send email to removed\_email\_address@domain.invalid For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~--- ---
**Author:** ![JannaB](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/df788c/32.png) [@JannaB](https://www.ruby-forum.com/u/JannaB)\ **Post date:** [June 6, 2009, 4:26am UTC](https://www.ruby-forum.com/t/creating-migrations/169625/4 "2009-06-06T04:26:28Z")
So, I guess the answer to my question – can I create migrations from a given sql schema, is no? ---
**Author:** ![JannaB](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/df788c/32.png) [@JannaB](https://www.ruby-forum.com/u/JannaB)\ **Post date:** [June 6, 2009, 5:35am UTC](https://www.ruby-forum.com/t/creating-migrations/169625/5 "2009-06-06T05:35:25Z")
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/](http://alinhavado.wordpress.com/) (pt-br) | [http://codeshooter.wordpress.com/](http://codeshooter.wordpress.com/) (en) ---
**Author:** ![JannaB](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/df788c/32.png) [@JannaB](https://www.ruby-forum.com/u/JannaB)\ **Post date:** [June 6, 2009, 5:45am UTC](https://www.ruby-forum.com/t/creating-migrations/169625/6 "2009-06-06T05:45:57Z")
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 [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)