Unfortunately we fell behind with our Umbraco implementation and needed to upgrade several versions at once.  I'm running into an issue where I need to be able to generate Sql scripts to run in production (while maintaining current data).  I am unable to simply use the Umbraco web interface that runs the database upgrades as this can only happen in a development or test environment. 

The application side took a little bit, but was not that difficult.  Using our current database (v. 4.0.2.1) and new installation of the latest version (v. 4.7.1), I used the redgate sql compare tool to generate a diff script.  While running it I ran into several issues creating various keys and indexes.  Some of these errors were a result of the existing data in our tables.  

Below I've copied the Sql output of the script execution.  I'm a little stumped at the moment on how to proceed with this upgrade.  Are there incremental scripts available somewhere in the source/core code I could run a version at a time?  I looked through the release on codeplex and did not have much luck finding those artifacts.  Any and all suggestions are greatly appreciated.

Dropping constraints from [dbo].[cmsContentVersion]
Creating [dbo].[cmsPreviewXml]
Creating primary key [PK_cmsContentPreviewXml] on [dbo].[cmsPreviewXml]
Altering [dbo].[cmsMacro]
Creating primary key [PK__cmsConte__3213E83F3B75D760] on [dbo].[cmsContentVersion]
Creating primary key [PK_cmsMember] on [dbo].[cmsMember]
Creating primary key [PK_cmsStylesheet] on [dbo].[cmsStylesheet]
Creating primary key [PK_cmsStylesheetProperty] on [dbo].[cmsStylesheetProperty]
Creating index [IX_Icon] on [dbo].[cmsContentType]
Creating index [IX_umbracoLog] on [dbo].[umbracoLog]
Adding constraints to [dbo].[cmsContent]
Adding constraints to [dbo].[cmsContentType]
Adding constraints to [dbo].[cmsContentVersion]
Adding constraints to [dbo].[cmsDataType]
Adding constraints to [dbo].[cmsDictionary]
Adding constraints to [dbo].[cmsDocument]
Adding constraints to [dbo].[cmsTaskType]
Adding constraints to [dbo].[cmsTemplate]
Adding constraints to [dbo].[umbracoLanguage]
Adding constraints to [dbo].[umbracoUser]
Msg 1505, Level 16, State 1, Line 1
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.umbracoUser' and the index name 'IX_umbracoUser'. The duplicate key value is (dxb4).
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsContentTypeAllowedContentType]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsContentTypeAllowedContentType_cmsContentType1'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsContentVersion]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContent' that match the referencing column list in the foreign key 'FK_cmsContentVersion_cmsContent'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsContentXml]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContent' that match the referencing column list in the foreign key 'FK_cmsContentXml_cmsContent'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsDataType]
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_cmsDataType_umbracoNode". The conflict occurred in database "NEB_Test0_Umbraco", table "dbo.umbracoNode", column 'id'.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsDataTypePreValues]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsDataType' that match the referencing column list in the foreign key 'FK_cmsDataTypePreValues_cmsDataType'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsDocument]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContent' that match the referencing column list in the foreign key 'FK_cmsDocument_cmsContent'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsDocumentType]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsDocumentType_cmsContentType'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsLanguageText]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsDictionary' that match the referencing column list in the foreign key 'FK_cmsLanguageText_cmsDictionary'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsMacroProperty]
Adding foreign keys to [dbo].[cmsMember]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContent' that match the referencing column list in the foreign key 'FK_cmsMember_cmsContent'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsMember2MemberGroup]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsMember' that match the referencing column list in the foreign key 'FK_cmsMember2MemberGroup_cmsMember'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsMemberType]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsMemberType_cmsContentType'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsPreviewXml]
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.cmsPreviewXml" because it does not exist or you do not have permissions.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsPropertyData]
Msg 547, Level 16, State 0, Line 1
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_cmsPropertyData_cmsPropertyType". The conflict occurred in database "NEB_Test0_Umbraco", table "dbo.cmsPropertyType", column 'id'.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsPropertyType]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsPropertyType_cmsContentType'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsStylesheet]
Adding foreign keys to [dbo].[cmsStylesheetProperty]
Adding foreign keys to [dbo].[cmsTab]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsContentType' that match the referencing column list in the foreign key 'FK_cmsTab_cmsContentType'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[cmsTask]
Adding foreign keys to [dbo].[cmsTemplate]
Msg 1776, Level 16, State 0, Line 1
There are no primary or candidate keys in the referenced table 'dbo.cmsTemplate' that match the referencing column list in the foreign key 'FK_cmsTemplate_cmsTemplate'.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
(1 row(s) affected)
Adding foreign keys to [dbo].[umbracoDomains]
Adding foreign keys to [dbo].[umbracoRelation]
Adding foreign keys to [dbo].[umbracoUser2NodeNotify]
Adding foreign keys to [dbo].[umbracoUser2NodePermission]
The database update failed