Project

General

Profile

Actions

Defect #1652

closed

migrations 91 and 92 fail against SQL Server 2005

Defect #1652: migrations 91 and 92 fail against SQL Server 2005

Added by Jason Morris over 18 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Resolution:
Invalid
Affected version:

Description

I just attempt to install redmine db onto sql server 2005 and received the following error when running rake db:migrate

91 ChangeChangesetsRevisionToString: migrating ===========================
-- change_column(:changesets, :revision, :string, {:null=>false})
rake aborted!
DBI::DatabaseError: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server
The index 'changesets_repos_rev' is dependent on column 'revision'.
HRESULT error code:0x80020009
Exception occurred.: ALTER TABLE changesets ALTER COLUMN revision varchar(255)

My workaround was to do the two migration manually, which worked fine. I then re-ran the migration and they worked...this also got my db version up to 92.


Files

MigrationPatchr1709.patch (1.53 KB) MigrationPatchr1709.patch Chris Taylor, 2008-07-29 21:49

Updated by Jean-Philippe Lang over 18 years ago Actions #1

  • Category set to Database
  • Status changed from New to Closed
  • Resolution set to Invalid

Please note that SQLServer database is not supported.

Updated by Chris Taylor over 18 years ago Actions #2

Migration 91 fails because an index was previously applied to the column, preventing Sql Server from altering it. Migration 92 fails because of a constraint applied to the column. The attached patch resolves both issues.

Actions

Also available in: PDF Atom