# Schema -\> migrations

**URL:** <https://www.ruby-forum.com/t/schema-migrations/101730>\
**Category:** Rails\
**Created:** [August 7, 2006, 6:06pm UTC](https://www.ruby-forum.com/t/schema-migrations/101730 "2006-08-07T18:06:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![john-anes](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/22d042/32.png) [@john-anes](https://www.ruby-forum.com/u/john-anes)\
**Post date:** [August 7, 2006, 6:06pm UTC](https://www.ruby-forum.com/t/schema-migrations/101730/1 "2006-08-07T18:06:48Z")

</div>

I’ve poked around a bit with Google and I can’t find a way to generate a  
base set of migrations from a given SQL schema. Is there an easy way to  
do this?

thanks  
John

---

<div class="post-metadata">

**Author:** ![john-anes](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/22d042/32.png) [@john-anes](https://www.ruby-forum.com/u/john-anes)\
**Post date:** [August 7, 2006, 6:24pm UTC](https://www.ruby-forum.com/t/schema-migrations/101730/2 "2006-08-07T18:24:51Z")

</div>

rake db\_schema\_dump

the above will work if you have your database already set up. try  
checking out: [http://www.recentrambles.com/pragmatic/view/51](http://www.recentrambles.com/pragmatic/view/51) for a  
little more info.

---

<div class="post-metadata">

**Author:** ![john-anes](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/22d042/32.png) [@john-anes](https://www.ruby-forum.com/u/john-anes)\
**Post date:** [August 8, 2006, 2:11pm UTC](https://www.ruby-forum.com/t/schema-migrations/101730/3 "2006-08-08T14:11:33Z")

</div>

On Mon, 2006-08-07 at 12:20 -0400, Charlie B. wrote:

> rake db\_schema\_dump

Thanks, that’s exactly what I needed.

bye  
John