yaml_db
yaml_db copied to clipboard
rake db:dump does not work with large tables on MS SQL Server
The call to ActiveRecord::Base.connection.add_limit_offset! needs an :offset parameter when using rails-mssql-2000-2005-adapter. This is non-standard, as far as the protocol for add_limit_offset! is concerned. Unfortunately, MS SQL Server needs the non-standard syntax because of limitations in its pagination capabilities. I cloned yaml_db and made the fix, but I can't test it without dumping over a gig of data.
I am having the similar problem with MySQL
undefined method `add_limit_offset!' for #ActiveRecord::ConnectionAdapters::Mysql2Adapter:0x007ff029da80d8