Re: [xwiki-users] Problem Migrating Database from XWiki Ent 3.5.1 to 4.1.3 for MSSQL

Okay, here is an Update: Using the xwiki.cfg file I posted to pastebin, I modified xwiki.store.migration=1 After restarting the server I am still getting the exact same error message in the browser. Looking at the DATABASECHANGELOG from inside the target database, the Liquibase executions get as far as removing the Foreign Keys. It seems to fail when attempting to change the datatype on the Primary Key for xwikiobjects. In the stdout file I am now seeing the following liquibase error when attempting to change the datatype on the Primary Key for xwikiobjects to BIGINT. 2012-08-03 08:21:00,691 [http://10.43.30.38:9080/xwiki/bin/view/Main/] ERROR c.x.x.s.m.liquibase - Change Set liquibase.xml::R40000-009::dgervalle failed. Error: Error executing SQL ALTER TABLE [dbo].[xwikiobjects] ALTER COLUMN [XWO_ID] BIGINT: The object 'PK__xwikiobj__6F7E67F86383C8BA' is dependent on column 'XWO_ID'. I believe the reason for this error is that on SQL Server the Primary Key constraint should to be dropped first before you can change the datatype. (At least that's what I found in my script testing). Would it be possible to see the liquibase changelogs for this migration? I'm not sure where in the package this information is stored. -- View this message in context: http://xwiki.475771.n2.nabble.com/Problem-Migrating-Database-from-XWiki-Ent… Sent from the XWiki- Users mailing list archive at Nabble.com.