Schema in SQL?

rubyonrails-talk
1

Is there a straightforward way (rake task?) to convert the generated ruby schema file into SQL? I want to do some visualization with MySQL Workbench, but the free version can't reverse engineer a live db - it needs a schema file in SQL. Any alternative suggestions or approaches are also welcome.

Thanks a ton in advance. -john

2

You can change environment.rb to use:

   config.active_record.schema_format = :sql

or I think that rake db:structure:dump will do it

JD

3

Check your config/environment.rb

config.active_record.schema_format = :sql

Uncomment that line, you’ll get an SQL file instead.

Jason

4

rake db:structure:dump did just the trick! thanks a lot. -john

James Deville wrote:

5

Is there a straightforward way (rake task?) to convert the generated ruby schema file into SQL? I want to do some visualization with MySQL Workbench, but the free version can't reverse engineer a live db - it needs a schema file in SQL. Any alternative suggestions or approaches are also welcome.

rake db:structure:dump # Dump the database structure to a SQL                                      file

or

mysqldump --no-data your_db > schema.sql