Redmine

activerecord-sqlserver-adapter 5.2.0.rc1 has been released on February 12.

activerecord-sqlserver-adapter 5.2.0 has been released on March 19.
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/blob/master/CHANGELOG.md#v520

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.

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.

I tested it on SQL Server 2017 with these gems
activerecord-sqlserver-adapter (5.2.0)
tiny_tds (2.1.2-x64-mingw32)

it passes all tests, but unfortunatelly there's a problem with migrations due to this bug
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/pull/691

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.

Is there any progress on this? I would definitely like to upvote this as I have clients on Sql Server. I would also be happy to test potential solutions in our dev environments.

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.

Pavel Rosický wrote:

if you're still interested, here's a patch for redmine

For those who like me had to search how to apply this patch, here the official Redmine's way.
http://www.redmine.org/projects/redmine/wiki/patch

Pavel Rosický wrote:

sorry, no feedback from activerecord-sqlserver-adapter's maintainers yet

but you can test my (unofficial) patch by changing the Gemfile
[...]

on my environment it passes all activerecord-sqlserver-adapter's tests and redmine's tests. Let us know if it works for you.

Hello. They have megred your issue, as I can see?
https://github.com/ahorek/activerecord-sqlserver-adapter.git
Is this problem solved?

Hiep Le
ok, try to change the Gemfile instead.

  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]

CR/LF issues is off-topic, please ask on forums if you need help
there're better alternatives than cygwin
https://rubyinstaller.org/downloads/ or https://en.wikipedia.org/wiki/Windows_Subsystem_for_Linux

Alexander Ryabinovskiy

Hello. They have megred your issue, as I can see?
https://github.com/ahorek/activerecord-sqlserver-adapter.git
Is this problem solved?

Go MAEDA wrote:

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.

Hi,
any news about this? I would like to use the latest version of redmine with mssql on windows. As far as I understand the answers in this thread do not solve the problem and currently there is no way to get the latest version of redmine running on mssql?

BR,
Bob

As far as I understand the answers in this thread do not solve the problem and currently there is no way to get the latest version of redmine running on mssql?
officially no, by using an unofficial patch yes. (https://www.redmine.org/issues/30285#note-16)

I'm not the maintainer of the https://github.com/rails-sqlserver/activerecord-sqlserver-adapter gem, so there's nothing more I can do. The current state of development seems to be pretty dead.

Great! When will 4.1.1 be released?

Pavel Rosický wrote:

activerecord-sqlserver-adapter 5.2.1 has been released on 31.3.2020. We should update the Gemfile.

+1
I think it's good. I confirmed using the Docker image "mcr.microsoft.com/mssql/server:2017-latest-ubuntu".