How can I export database structure from the db into migration file?

ruby-on-rails rake rake-task
user482594 picture user482594 · Sep 18, 2011 · Viewed 8.8k times · Source

Is there a way to export database structure in the database from the rails application? I believe there is a way to export Data from the db using rake.

rake db:migrate will create tables from migration files. Is there a command that does opposite way so that migration files will be generated from the db?

I have previously built a rails application during 3.0.x version.

I have many more migration files than the actual number of tables in the database because I have some migration file which adds and removes or change the column structure of the database.

Obviously, I can manually change each migration file and change it into migration file with 3.1 standard, but I just want to know if there is a way to export data base structure. (Or, deriving from existing schema file)

Answer

datalost picture datalost · Sep 18, 2011

Use command rake db:schema:dump, it will do it for you

Edit: You might be interested in this link: http://www.tutorialspoint.com/ruby-on-rails/rails-and-rake.htm

Related questions

Simple rails rake task refuse to run with error "Don't know how to build task", why?

I have this simple rake task which refuses to run. I just don't see why it looks correct. Who can pinpoint me to the probably very simple mistake I made? Thank you! /lib/tasks/reindex.rb: namespace :db do desc "…

Read More
How to execute commands within Rake tasks?

I have the rake tasks in my rails application. i want to run a commandline commands with in rake task. how can i do this. i tried by the following but fails desc "Sending the newsletter to all the users" …

Read More
How to build task 'db:populate'

1 namespace :db do 2 desc "Fill database with sample videos" 3 task :populate => :environment do 4 require 'faker' 5 Rake::Task['db:reset'].invoke 6 100.times do |n| 7 headline = Faker::Lorem.sentence(3) 8 video = Faker::Lorem.words(5) 9 Video.create!(:headline => headline, 10 :video => video) 11 …

Read More