The migration completes with errors.

transaction log:

BEGIN TRANSACTION TransactionMigration
@bitMigrateCommunity:          0
@bitMigrateMail:          1
@bitEPiServerCommonSourceExists:          1
@bitEPiServerCommonTargetExists:          1
@bitCommunitySourceExists:          0
@bitCommunityTargetExists:          0
@bitEPiMailSourceExists:          1
@bitEPiMailTargetExists:          1
@bitEPiServerCommonTablesEmpty:          1
@bitEPiServerCommunityTablesEmpty:          1
@bitEPiMailTablesEmpty:          1
Data migration started
Truncate tables
Copy globalization keys
Copy Common Framework data to destination
Retrieving Object type IDs...
 
Object type IDs
--------------------
Calendar = 3
CalendarEvent = 4
ForumReply = 6
ForumTopic = 7
ForumRoom = 5
Video = 8
VideoGallery = 9
VideoComment = 10
Image = 11
ImageComment = 13
ImageGallery = 12
Blog = 14
BlogEntry = 15
EntryComment = 16
User = 1
Club = 17
UserAuthor = 18
AnonymousAuthor = 19
GuestAuthor = 20
ReportCase = 21
ContactContainer = 22
DocumentArchive = 23
Forum = 24
Poll = 25
Campaign = 26
NewsFeed = 27
MyPage = 28
--------------------
 
Copy EPiServerMail data
Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 1
The UPDATE statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_tblEPiServerCommonCategory_tblEPiServerCommonCategory_Parent". The conflict occurred in database "EPiServerMailDBDev", table "dbo.tblEPiServerCommonCategory", column 'intID'.
The statement has been terminated.
COMMIT TRANSACTION TransactionMigration

When investigating and comparing tables between the databases the target got corrupted tables.

Migration setup:

-- Set global variables
SET @strSourceDB = '[EpiServerMailDBTestData]'
SET @strTargetDB = '[EPiServerMailDBDev]'
SET @bitMigrateCommunity = 0
SET @bitMigrateMail = 1
SET @bitDebug = 1
SET @bitRestoreRelatePlusData = 0

 Any idea why or did i miss something ?