# rake migration not working

**URL:** <https://discuss.rubyonrails.org/t/rake-migration-not-working/2908>\
**Category:** rubyonrails-talk\
**Created:** [October 10, 2006, 11:02pm UTC](https://discuss.rubyonrails.org/t/rake-migration-not-working/2908 "2006-10-10T23:02:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kbob](https://avatars.discourse-cdn.com/v4/letter/k/7feea3/32.png) [@kbob](https://discuss.rubyonrails.org/u/kbob)\
**Post date:** [October 10, 2006, 11:02pm UTC](https://discuss.rubyonrails.org/t/rake-migration-not-working/2908/1 "2006-10-10T23:02:14Z")

</div>

Rakesh Malhotra \<rails-mailing-list@...\> writes:

> When I do rake migrate only two tables get created on my persoal

oracle

> database. Rest of them do not get created. I see schema.rb in db directory and I can only see 2 tables created.

Are these in one migration or multiple migrations?

There were no error messages when you ran the Rake task?

Run rake migrate --trace; that might give you a more detailed view of what's going on.

BTW, I always run my migrations inside a transaction, so either it all works or nothing gets saved: &nbsp;&nbsp;def self.up &nbsp;&nbsp;&nbsp;&nbsp;ActiveRecord::Base.transaction do &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.. migration stuff here &nbsp;&nbsp;&nbsp;&nbsp;end &nbsp;&nbsp;end

---

<div class="post-metadata">

**Author:** ![Ali1](https://avatars.discourse-cdn.com/v4/letter/a/76d3ee/32.png) [@Ali1](https://discuss.rubyonrails.org/u/Ali1)\
**Post date:** [October 11, 2006, 3:27am UTC](https://discuss.rubyonrails.org/t/rake-migration-not-working/2908/2 "2006-10-11T03:27:13Z")

</div>

Does ActiveRecord::Base.transaction support DDL transactions? I think most databases implicitly commit after any DDL statement. I dont think creating multiple tables in a transaction will be all or nothing.

Ali

---

<div class="post-metadata">

**Author:** ![Tom\_Mornini1](https://avatars.discourse-cdn.com/v4/letter/t/35a633/32.png) [@Tom\_Mornini1](https://discuss.rubyonrails.org/u/Tom_Mornini1)\
**Post date:** [October 11, 2006, 4:34am UTC](https://discuss.rubyonrails.org/t/rake-migration-not-working/2908/3 "2006-10-11T04:34:13Z")

</div>

I believe Postgres and MS SQL Server support DDL transactions.

MySQL and Oracle do not, not sure about the others.

All of this is from memory from a discussion at RailsConf 2006.

Apologies in advance if I'm mistaken.