# How: From database to "schema.rb" file ?

**URL:** <https://discuss.rubyonrails.org/t/how-from-database-to-schema-rb-file/40134>\
**Category:** rubyonrails-talk\
**Created:** [March 6, 2009, 1:15pm UTC](https://discuss.rubyonrails.org/t/how-from-database-to-schema-rb-file/40134 "2009-03-06T13:15:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [March 6, 2009, 1:15pm UTC](https://discuss.rubyonrails.org/t/how-from-database-to-schema-rb-file/40134/1 "2009-03-06T13:15:12Z")

</div>

Hi there!

Is there a way to get a complete/up-to-date "schema.rb" file, based on just the database? (without using any migration files...)

---

<div class="post-metadata">

**Author:** ![Mauricio\_Linhares1](https://avatars.discourse-cdn.com/v4/letter/m/eada6e/32.png) [@Mauricio\_Linhares1](https://discuss.rubyonrails.org/u/Mauricio_Linhares1)\
**Post date:** [March 6, 2009, 1:16pm UTC](https://discuss.rubyonrails.org/t/how-from-database-to-schema-rb-file/40134/2 "2009-03-06T13:16:13Z")

</div>

rake db:schema:dump

---

<div class="post-metadata">

**Author:** ![11175](https://avatars.discourse-cdn.com/v4/letter/1/8edcca/32.png) [@11175](https://discuss.rubyonrails.org/u/11175)\
**Post date:** [March 6, 2009, 1:22pm UTC](https://discuss.rubyonrails.org/t/how-from-database-to-schema-rb-file/40134/3 "2009-03-06T13:22:41Z")

</div>

Thanks a lot !