Microsoft SQL server support is broken
|Target version:||Candidate for next minor release|
Redmine 4.0.0 does not work with Microsoft SQL Server.
One of the causes is that a dependent library activerecord-sqlserver-adapter does not support Rails 5.2 yet.
activerecord-sqlserver-adapter 5.2.0 has been released on March 19.
Can anyone test if Redmine 4.0 works with MS SQL Server? Please note that you have to run
bundle update to install the latest activerecord-sqlserver-adapter gem.
#13 Updated by sebastián scarano 2 months ago
yeap, here's the release, it would be great if redmine latest version could be confirmed to work ok with sql server...
and update the note at http://www.redmine.org/projects/redmine/wiki/RedmineInstall#Supported-database-back-ends
Redmine 4.0 does not support SQL Server as of December 2018 because a dependent library activerecord-sqlserver-adapter does not support Rails 5.2 yet.
#14 Updated by Pavel Rosický 2 months ago
I tested it on SQL Server 2017 with these gems
it passes all tests, but unfortunatelly there's a problem with migrations due to this bug
TinyTds::Error: The object 'DF_projects_description' is dependent on column 'description'. 087_change_projects_description_to_text.rb:5:in `up'
there might be an option to add a workaround in redmine, but it won't be pretty, so I would prefer to fix the problem in activerecord-sqlserver-adapter.
#16 Updated by Pavel Rosický 28 days ago
sorry, no feedback from activerecord-sqlserver-adapter's maintainers yet
but you can test my (unofficial) patch by changing the Gemfile
when /sqlserver/ gem "tiny_tds", "2.1.2", :platforms => [:mri, :mingw, :x64_mingw] gem "activerecord-sqlserver-adapter", :git => 'https://github.com/ahorek/activerecord-sqlserver-adapter.git', :branch => 'constrains_bug', :platforms => [:mri, :mingw, :x64_mingw]
on my environment it passes all activerecord-sqlserver-adapter's tests and redmine's tests. Let us know if it works for you.