Tried to upgrade from 4.0.8 to 5.1.1 and the db script failed. The contents of the 05.01.00.log file is below:
System.Data.SqlClient.SqlException: Constraint 'PK_EventLogMaster' does not belong to table 'imsdnnuser_EventLog'.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Change primary key of EventLog Table */
/****************************************/
IF NOT EXISTS (SELECT 1 FROM INformATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'imsdnnuser.imsdnnuser_EventLog' AND COLUMN_NAME = 'LogEventID')
BEGIN
--Note this name does NOT have an object qualifier in 4.x upgrades
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_EventLogMaster'))
ALTER TABLE imsdnnuser.imsdnnuser_EventLog
DROP CONSTRAINT PK_EventLogMaster
--Note this name does have an object qualifier in 5.x installs
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_imsdnnuser_EventLogMaster'))
ALTER TABLE imsdnnuser.imsdnnuser_EventLog
DROP CONSTRAINT PK_imsdnnuser_EventLogMaster
--Some scenarios have the primary key as PK_imsdnnuser_EventLog
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'PK_imsdnnuser_EventLog'))
ALTER TABLE imsdnnuser.imsdnnuser_EventLog
DROP CONSTRAINT PK_imsdnnuser_EventLog
ALTER TABLE imsdnnuser.imsdnnuser_EventLog
ADD LogEventID bigint NOT NULL IDENTITY (1, 1)
ALTER TABLE imsdnnuser.imsdnnuser_EventLog
ADD CONSTRAINT PK_imsdnnuser_EventLogMaster PRIMARY KEY CLUSTERED ( LogEventID )
END