Defect #8028

Migration error under MSSQL 2000

Added by Petr Pospisil over 7 years ago. Updated 10 months ago.

Status:ClosedStart date:2011-03-31
Priority:NormalDue date:
Assignee:-% Done:


Category:DatabaseEstimated time:0.50 hour
Target version:-
Resolution:Wont fix Affected version:1.1.2



I tried to install the Redmine on MSSQL 2000 and I had to change a migration file, because some kind of error occured on MSSQL side. (cannot change a column because it is in use by other object)

line 3 change_column :changesets, :revision, :string, :null => false

remove_index :changesets, :name => :changesets_repos_rev
change_column :changesets, :revision, :string, :null => false
add_index :changesets, [:repository_id, :revision], :unique => true, :name => :changesets_repos_rev



#1 Updated by Jean-Philippe Lang over 7 years ago

MSSQL is not officially supported (and totally untested) but I'm curious about how Redmine behaves with it.
Did all other migrations run fine?

#2 Updated by Petr Pospisil over 7 years ago

yep, only this one.

But I don't know if all pages are working as expected, I tested only migration.

#3 Updated by Go MAEDA 10 months ago

  • Status changed from New to Closed
  • Resolution set to Wont fix

Since SQL Server 2000 is too old, I am closing this issue.

Also available in: Atom PDF