Can I generate a ruby on rails database migration file from a MySQL sql file

Question

I have a sql script file that upon import creates a table in a MySQL database and fills it with 2800 record. These are all the postal codes for the country Belgium.

Now I would like to make a Ruby on Rails database migration file from this. Any idea how I can do this?

Maybe there is a way around? Telling in a database migration file to execute a separate sql script?

Thanks, Michael

duncan · Accepted Answer · 2010-05-02 20:22:41Z

11

If your config/database.yml is referencing the MySQL database with the schema, then do

rake db:schema:dump

That will create a db/schema.rb file which is database independent.

Copy schema.rb into db/migrate/001_original_schema.rb:

class OriginalDatabaseMigration < ActiveRecord::Migration
  def self.up
    # schema.rb here
  end

  def self.down
    # drop all the tables
  end
end

answered May 2, 2010 at 20:22

duncan

6,2933 gold badges32 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Michael Torfs Over a year ago

Hi, Thanks! Just tried it, it generates indeed the structure of the table. Is there also a command that will also include a dump of the records in the tables?

duncan Over a year ago

If you need to add records which are needed so that the database is usable, then don't do it it in the migrations which is for the database schema. Rails now has a special place for initial data. Use db/seeds.rb. You can convert/dump them to fixtures (google) and then use Fixtures.load or YAML.load with the associated ActiveRecord model to create the entries, or if you got them in a text file, just read it iterating while calling Postalnumber.create. You can even use open-uri and get the data from the internet in seed.rb :-)

Collectives™ on Stack Overflow

Can I generate a ruby on rails database migration file from a MySQL sql file

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related