Project

General

Profile

My apologies for submitting SQL Server issues but which databases are officially supported?

Added by Jason Morris over 15 years ago

I see that defect #1652 has been closed by Jean-Philippe Lang with the comment that SQL Server is not supported. I did not see this before issuing defect #1683. I do not want to cause more work for Jean-Philippe or the dev team by having to process issues against an unsupported database, but I was under the impression that SQL Server was supported due to references in the change log and various posts, patches, etc on the forums and trackers.

== 2006-07-09 - v0.2.1

  • new databases supported: Oracle, PostgreSQL, SQL Server

I understand this was for an old version, but I did not see the removal of SQLServer support, so my apologies for requesting fixes to unsupported things.

Maybe calling out the databases that are supported on the home wiki page in the overview section in the bullet "Multiple databases support" would help others to avoid my mistake. I did finally find it on the the Features page, way at the bottom.

Is redmine willing to add support for sql server? I see that several people have patches and procedures (http://www.redmine.org/boards/1/topics/show/1770) in getting it to work?


Replies (2)

RE: My apologies for submitting SQL Server issues but which databases are officially supported? - Added by Eric Davis over 15 years ago

That comment is from over a year ago. Since then the database support has changed for Redmine and also for Ruby on Rails (Redmine's web framework). MySQL, PostgreSQL and SQLite are the officially supported databases (as you found on http://www.redmine.org/wiki/redmine/Features). Others might work but I don't think the dev team has easy access to these so support is dependent on other community members.

Eric

RE: My apologies for submitting SQL Server issues but which databases are officially supported? - Added by Chris Taylor over 15 years ago

I've been spending a bit of time getting Sql Server 2005 working with Redmine. It now works almost out-of-the-box with a suitable sql adapter in Rails.

There's just a couple of changes needed in Redmine itself which solve the remaining issues. In a couple of cases in the code the same order-by clause gets applied twice (which causes Sql 2005 to fall over!). The other change is a very small fix to a couple of migrations to drop and recreate an index when altering a column, and set a default value when altering the column. I realise Sql Server 2005 isn't officially supported, but is there any chance that if I submitted a patch it would be accepted anyway?

    (1-2/2)