Convert Ruby ActiveRecord Schema to SQL syntax

Question

I haven't used Ruby much but I am trying to learn. I found a 'schema.db' file that looks like it is generated by Active Record module.

I am trying to figure out how do I convert this file into SQL so I can import it into my database?

DanS · Accepted Answer · 2011-02-23 16:27:00Z

1

Active Record does generate schema.rb and it represents the current state of the database (useful for getting a quick idea of what attributes each model has).

It is used when deploying new instances of an app, rather than replaying the whole migration history (and is also how the test database is created)

As an example, here's how you can deploy the production database:

RAILS_ENV=production rake db:create db:load

edited Feb 23, 2011 at 16:27

answered Feb 23, 2011 at 13:58

DanS

18.8k9 gold badges55 silver badges47 bronze badges

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

2 Comments

RishiD Over a year ago

Oh that sounds snazzy. I will try that and then I can do a dump from my database interface. Thanks.

Keith Bennett Over a year ago

Other rake:db commands might be helpful too, such as rake db:reset. A handy guide is at jacopretorius.net/2014/02/….

Collectives™ on Stack Overflow

Convert Ruby ActiveRecord Schema to SQL syntax

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related