I seem to be running into various issues between SqlServer and Rails, and so far have been able to solve everything save for a particular quirk when running unit tests.
When I run "rake test:units" on my app, it gets so far as to run db:schema:load. I'm dealing with a legacy database, so it's loading all sorts of tables that I don't care about, but regardless, one table in particular has a column set to VARCHAR(MAX). db:schema:dump interprets "MAX" as a limit of -1.
Is there a way to set the limit information during the schema dump? I'd be happy with just setting it to 8000 instead of MAX for testing purposes.
I suppose at the very least, I'd like to specify the schema.rb file myself without rake running db:schema:dump and overwriting my changes.