Mar 03

Rails - dump database structure for SQL Server

Dumping structure with _rake db:structure:dump_ task when connecting to SQL Server will fail with _scptxfr_ not found error.

Dumping structure with _rake db:structure:dump_ task when connecting to SQL Server will fail with _scptxfr_ not found error. 
command not found: scptxfr /s  /d  /I /F db /q /A /r
Thats documented in "#3298":http://dev.rubyonrails.org/ticket/3298. However dump of database structure can be easily achived from ActiveRecord: 
script/console
>> ActiveRecord::SchemaDumper.dump
Tags:

Related posts:

  1. source on Rails
  2. Create URL's outside of controllers and views
  3. Ruby / Rails alternative to PHP print_r() and var_dump()