# Sql -\> migrations?

**URL:** <https://www.ruby-forum.com/t/sql-migrations/169108>\
**Category:** Rails\
**Created:** [May 29, 2009, 3:32pm UTC](https://www.ruby-forum.com/t/sql-migrations/169108 "2009-05-29T15:32:59Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**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:** [May 29, 2009, 3:32pm UTC](https://www.ruby-forum.com/t/sql-migrations/169108/1 "2009-05-29T15:32:59Z")

</div>

Is there a way to take a db schema (say, as sql statements) and  
reverse that back into files to use for migrations? how do you handle  
legacy db’s – do you have to go and write the migration files  
yourself from scratch? -Janna B.

---

<div class="post-metadata">

**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:** [May 30, 2009, 1:28am UTC](https://www.ruby-forum.com/t/sql-migrations/169108/2 "2009-05-30T01:28:45Z")

</div>

Try pointing your config/database.yml at your legacy db & run ‘rake  
db:schema:dump’. That should dump the current schema out to  
db/schema.rb.

HTH,

-Roy