rake db:schema:load vs. migrations

by

Migrations provide forward and backward step changes to the database. In a production environment, incremental changes must be made to the database during deploys: migrations provide this functionality with a rollback failsafe. If you run rake db:schema:load on a production server, you’ll end up deleting all your production data. This is a dangerous habit to get into.

That being said, I believe it is a decent practice to occasionally “collapse” migrations. This entails deleting old migrations, replacing them with a single migration (very similar to your schema.rb file) and updating the schema_migrations table to reflect this change. Be very careful when doing this! You can easily delete your production data if you aren’t careful.

As a side note, I strongly believe that you should never put data creation in the migration files. The seed.rb file can be used for this, or custom rake or deploy tasks. Putting this into migration files mixes your database schema specification with your data specification and can lead to conflicts when running migration files.

More Related Contents:

  1. How can I rename a database column in a Ruby on Rails migration?
  2. Rails DB Migration – How To Drop a Table?
  3. Adding foreign key to a rails model
  4. How to get a random number in Ruby
  5. Why do routes with a dot in a parameter fail to match?
  6. Rails 3: “field-with-errors” wrapper changes the page appearance. How to avoid this?
  7. Heroku push rejected, no Cedar-supported app detected
  8. When to use a “has_many :through” relation in Rails?
  9. Ruby on Rails 3: Streaming data through Rails to client
  10. How to fix the uninitialized constant Rake::DSL problem on Heroku?
  11. Rails 3: Multiple Select with has_many through associations
  12. Rails 3 SQLite3 Boolean false
  13. How do you write a migration to rename an ActiveRecord model and its table in Rails?
  14. Rails update_attributes without save?
  15. Rails 3 submit a form with multiple records
  16. Rails 3 UTF-8 query string showing up in URL?
  17. How to match accented characters with a regex?
  18. f.error_messages in Rails 3.0
  19. Convert UTC to local time in Rails 3
  20. Scope with join on :has_many :through association
  21. What does do in rails erb?
  22. Rails form_for :remote=>true is not calling js method
  23. Remote mysql database on Heroku app
  24. How to add bootstrap modal with link_to so the link content open in modal ?
  25. How to implement bulk insert in Rails 3
  26. Index on multiple columns in Ruby on Rails
  27. Ruby on rails 4 app does not work in iframe
  28. Rails 3.1 include_root_in_json
  29. Rails: Order with nulls last
  30. Why should we avoid using class variables @@ in rails?

Leave a Comment