yaml_db icon indicating copy to clipboard operation
yaml_db copied to clipboard

rake db:dump does not work with large tables on MS SQL Server

Open listrophy opened this issue 15 years ago • 1 comments

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.

listrophy avatar May 17 '09 18:05 listrophy

I am having the similar problem with MySQL

undefined method `add_limit_offset!' for #ActiveRecord::ConnectionAdapters::Mysql2Adapter:0x007ff029da80d8

nextofsearch avatar Feb 07 '12 15:02 nextofsearch