Hello,

I'm attempting to upgrade my Umbraco website from 4.7 to 6.1.
I followed the step by step procedure for each incremental version from 4.7 to 6.1 and merged the config files accordingly.

Then, while trying the upgrade procedure, I stay stuck at the "Database Connection" step (5%).

Here is what i get in the logs :

2013-06-03 12:12:39,822 [17] INFO  Umbraco.Core.ApplicationContext - [Thread 25] CurrentVersion different from configStatus: '6.1.0','4.7.0'

2013-06-03 12:12:39,822 [17] WARN  Umbraco.Web.UmbracoModule - [Thread 25] Umbraco is not configured

2013-06-03 12:12:40,204 [17] INFO  Umbraco.Core.ApplicationContext - [Thread 18] CurrentVersion different from configStatus: '6.1.0','4.7.0'

2013-06-03 12:12:40,204 [17] WARN  Umbraco.Web.UmbracoModule - [Thread 18] Umbraco is not configured

2013-06-03 12:13:13,022 [17] INFO  Umbraco.Core.ApplicationContext - [Thread 8] CurrentVersion different from configStatus: '6.1.0','4.7.0'

2013-06-03 12:13:13,022 [17] INFO  Umbraco.Web.UI.Install.InstallerRestService - [Thread 8] Running 'InstallOrUpgrade' service

2013-06-03 12:13:13,022 [17] INFO  Umbraco.Core.DatabaseContext - [Thread 8] Database configuration status: Started

2013-06-03 12:13:13,023 [17] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Initializing database migrations

2013-06-03 12:13:13,024 [17] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Added UPGRADE migration 'RemoveUmbracoAppConstraints' to context

2013-06-03 12:13:13,024 [17] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Added UPGRADE migration 'RenameCmsTabTable' to context

2013-06-03 12:13:13,024 [17] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Added UPGRADE migration 'UpdateCmsPropertyTypeGroupTable' to context

2013-06-03 12:13:13,024 [17] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Added UPGRADE migration 'UpdateCmsContentTypeTable' to context

2013-06-03 12:13:13,024 [17] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Added UPGRADE migration 'UpdateCmsContentTypeAllowedContentTypeTable' to context

2013-06-03 12:13:13,024 [17] INFO  Umbraco.Core.Persistence.Migrations.MigrationRunner - [Thread 8] Added UPGRADE migration 'NewCmsContentType2ContentTypeTable' to context

2013-06-03 12:13:13,202 [17] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 8]    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()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

   at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()

2013-06-03 12:13:13,202 [17] INFO  Umbraco.Core.DatabaseContext - [Thread 8] Database configuration failed with the following error and stack trace: Invalid column name 'masterContentType'.

Invalid column name 'masterContentType'.

Invalid column name 'masterContentType'.

   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()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)

   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

   at Umbraco.Core.Persistence.Database.<Query>d__7`1.MoveNext()

   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

   at Umbraco.Core.Persistence.Migrations.Upgrades.TargetVersionSix.MoveMasterContentTypeData.Up()

   at Umbraco.Core.Persistence.Migrations.MigrationBase.GetUpExpressions(IMigrationContext context)

   at Umbraco.Core.Persistence.Migrations.MigrationRunner.Execute(Database database, DatabaseProviders databaseProvider, Boolean isUpgrade)

   at Umbraco.Core.DatabaseContext.CreateDatabaseSchemaAndDataOrUpgrade()

2013-06-03 12:13:13,202 [17] INFO  Umbraco.Core.DatabaseContext - [Thread 8] The database schema validation produced the following summary: 

The following tables were found in the database, but are not in the current schema:

Comment,fullTextCache,UFWorkflowsToForms,UFSettings,UFPrevalueSources,UFUserSecurity,UFDataSources,UFFormStates,UFPrevalueSourceSettings,UFDataSourceMappings,UFForms,UFWorkflowExecutionStates,UFWorkflows,UFRecordsXml,UFRecords,UFUserFormSecurity,UFPages,UFRecordFields,UFFieldsets,UFFields,UFFieldSettings,UFPrevalues,UFRecordDataString,UFRecordDataLongString,UFRecordDataInteger,UFRecordDataDateTime,UFRecordDataBit

 

The following columns were found in the database, but are not in the current schema:

Comment,id,Comment,mainid,Comment,nodeid,Comment,name,Comment,email,Comment,website,Comment,comment,Comment,spam,Comment,ham,Comment,created,fullTextCache,Id,fullTextCache,nodeId,fullTextCache,fullHTML,UFWorkflowsToForms,Workflow,UFWorkflowsToForms,Form,UFSettings,Id,UFSettings,Key,UFSettings,Value,UFPrevalueSources,Id,UFPrevalueSources,Name,UFPrevalueSources,Type,UFUserSecurity,User,UFUserSecurity,ManageDataSources,UFUserSecurity,ManagePreValueSources,UFUserSecurity,ManageWorkflows,UFUserSecurity,ManageForms,UFDataSources,Id,UFDataSources,Type,UFDataSources,Name,UFFormStates,State,cmsContentTypeAllowedContentType,sortOrder,UFPrevalueSourceSettings,PrevalueProvider,UFPrevalueSourceSettings,Key,UFPrevalueSourceSettings,Value,UFDataSourceMappings,DataSource,UFDataSourceMappings,DataSourceField,UFDataSourceMappings,Form,UFDataSourceMappings,PrevalueTable,UFDataSourceMappings,PrevalueKeyField,UFDataSourceMappings,PrevalueValueField,UFDataSourceMappings,DataType,UFDataSourceMappings,DefaultValue,UFForms,Id,UFForms,Name,UFForms,Created,UFForms,ManualApproval,UFForms,GotoPageOnSubmit,UFForms,MessageOnSubmit,UFForms,DataSource,UFForms,ShowValidationSummary,UFForms,HideFieldValidation,UFForms,RequiredErrorMessage,UFForms,InvalidErrorMessage,UFForms,FieldIndicationType,UFForms,Indicator,UFForms,Archived,UFForms,StoreRecordsLocally,UFForms,DisableDefaultStylesheet,UFForms,Entries,UFForms,Views,UFWorkflowExecutionStates,Workflow,UFWorkflowExecutionStates,State,UFWorkflowExecutionStates,Form,UFWorkflows,Id,UFWorkflows,Name,UFWorkflows,Type,UFWorkflows,SortOrder,UFWorkflows,Active,UFWorkflows,Form,UFWorkflows,ExecutesOn,UFRecordsXml,id,UFRecordsXml,Form,UFRecordsXml,xml,UFRecordsXml,created,UFRecordsXml,Page,UFRecords,Id,UFRecords,Form,UFRecords,Created,UFRecords,Updated,UFRecords,State,UFRecords,currentPage,UFRecords,umbracoPageId,UFRecords,IP,UFRecords,MemberKey,UFUserFormSecurity,User,UFUserFormSecurity,Form,UFUserFormSecurity,HasAccess,UFUserFormSecurity,SecurityType,UFUserFormSecurity,AllowInEditor,UFPages,Id,UFPages,Form,UFPages,SortOrder,UFPages,Caption,UFRecordFields,Key,UFRecordFields,Field,UFRecordFields,Record,UFRecordFields,DataType,UFFieldsets,Id,UFFieldsets,Page,UFFieldsets,SortOrder,UFFieldsets,Caption,UFFields,Id,UFFields,Fieldset,UFFields,Fieldtype,UFFields,PreValueProvider,UFFields,RegEx,UFFields,Mandatory,UFFields,SortOrder,UFFields,Caption,UFFields,DataSourceField,UFFields,ToolTip,UFFields,DefaultValue,UFFields,RequiredErrorMessage,UFFields,InvalidErrorMessage,UFFieldSettings,Field,UFFieldSettings,Key,UFFieldSettings,Value,UFPrevalues,Id,UFPrevalues,Field,UFPrevalues,Value,UFPrevalues,SortOrder,UFRecordDataString,Key,UFRecordDataString,Value,UFRecordDataLongString,Key,UFRecordDataLongString,Value,UFRecordDataInteger,Key,UFRecordDataInteger,Value,UFRecordDataDateTime,Key,UFRecordDataDateTime,Value,UFRecordDataBit,Key,UFRecordDataBit,Value,cmsTags,parentId

 

The following constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:

FK_cmsContent_umbracoNode,FK_cmsContentType_umbracoNode,FK_cmsContentVersion_cmsContent,FK_cmsContentXml_cmsContent,FK_cmsDataType_umbracoNode,FK_cmsDataTypePreValues_cmsDataType,FK_cmsDocument_cmsContent,FK_cmsDocument_cmsTemplate,FK_cmsDocument_umbracoNode,FK_cmsDocumentType_cmsContentType,FK_cmsDocumentType_cmsTemplate,FK_cmsDocumentType_umbracoNode,FK_cmsLanguageText_cmsDictionary,FK_cmsMacroProperty_cmsMacro,FK_cmsMember_cmsContent,FK_cmsMember_umbracoNode,FK_cmsMember2MemberGroup_cmsMember,FK_cmsMember2MemberGroup_umbracoNode,FK_cmsMemberType_cmsContentType,FK_cmsMemberType_umbracoNode,FK_cmsPreviewXml_cmsContent,FK_cmsPreviewXml_cmsContentVersion,FK_cmsPropertyData_cmsPropertyType,FK_cmsPropertyData_umbracoNode,FK_cmsPropertyType_cmsContentType,FK_cmsPropertyType_cmsDataType,FK_cmsPropertyType_cmsTab,FK_cmsPropertyTypeGroup_cmsPropertyTypeGroup,FK_cmsStylesheet_umbracoNode,FK_cmsStylesheetProperty_umbracoNode,FK_cmsTab_cmsContentType,FK_cmsTask_cmsTaskType,FK_cmsTask_umbracoNode,FK_UFDataSourceMappings_UFDataSources,FK_UFDataSourceMappings_UFForms,FK_UFField_UFFieldsets,FK_UFFieldsets_UFPages,FK_UFFieldSettings_UFFields,FK_UFForms_UFDataSources,FK_UFPages_UFForms,FK_UFPrevalues_UFFields,FK_UFPrevalueSettings_UFPrevalueProviders,FK_UFRecordDataBit_UFRecordFields,FK_UFRecordDataDateTime_UFRecordFields,FK_UFRecordDataInteger_UFRecordFields,FK_UFRecordDataLongString_UFRecordFields,FK_UFRecordDataString_UFRecordFields,FK_UFRecordFields_UFFields,FK_UFRecordFields_UFRecords,FK_UFRecords_UFForms,FK_UFRecordsXml_UFForms,FK_UFUserFormSecurity_UFForms,FK_UFWorkflowExecutionStates_UFFormStates,FK_UFWorkflows_UFForms,FK_umbracoDomains_umbracoNode,FK_umbracoMacroProperty_umbracoMacroPropertyType,FK_umbracoNode_umbracoNode,FK_umbracoRelation_umbracoRelationType,FK_umbracoUser2app_umbracoUser,FK_umbracoUser2NodeNotify_umbracoNode,FK_umbracoUser2NodeNotify_umbracoUser,FK_umbracoUser2NodePermission_umbracoNode,FK_umbracoUser2NodePermission_umbracoUser,FK_user_userType,PK__cmsConte__3213E83F3B75D760,PK_cmsContentPreviewXml,PK_cmsTab,PK_Comment,PK_domains,PK_fullTextCache,PK_language,PK_macro,PK_macroProperty,PK_macroPropertyType,PK_templates,PK_UFDataSourceMappings,PK_UFDataSources,PK_UFField,PK_UFFieldsets,PK_UFForms,PK_UFFormStates,PK_UFPages,PK_UFPrevalueProviders,PK_UFPrevalues,PK_UFPrevalueSettings,PK_UFRecordFields,PK_UFRecords,PK_UFRecordsXml,PK_UFUserFormSecurity,PK_UFUserSecurity,PK_UFWorkflowExecutionStates,PK_UFWorkflows,PK_UFWorkflowsToForms,PK_userType,IX_cmsContentVersion,IX_cmsDataType,IX_cmsDictionary,IX_cmsTaskType,IX_cmsTemplate,IX_umbracoLanguage,IX_umbracoUser

 

The following unknown constraints (Primary Keys, Foreign Keys and Indexes) were found in the database, but are not in the current schema:

cmsTags_cmsTagRelationship,umbracoNode_cmsTagRelationship