Data Truncated error during Migration to MSSQL from MYSQL
Hello we are migrating from MYSQL to MSSQL and when trying to restore the database to MSSQL we are getting the following error
Restoring process started.Deleting previous .sql files if any
Is Partial Restore Eligible : true
Is Partial Restore : true
Partial Restore Initiated.
Deleting failure table...
Error Tables : wordmap,wordoccurrences
AuditRecord
OperationAuditRecord
AuditOperProperty
AuditResultProperty
AuditResourceProp
AaaAccSession
AaaAccSessionProp
AaaAccHttpSession
AaaAccSessionAudit
RecentItems
WmiSWUsageInfo
MaxUsedSwInfo
SWInstallationKeyInfo
UnInsSoftwareInfo
SDUserProfileQUERY = INSERT INTO SDUserProfile (USERID,TIMEZONEID,DATE_FORMAT,TIME_FORMAT,SIGNATURE,KBSHORTCUTS,PROFILE_PIC_PATH) VALUES(8438, 69, N'yyyy.MM.dd', N'MMM d, yyyy hh:mm a', N'<p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><font size="3"><b><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">Kelly Kaneda</span></b><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: #636466; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes; mso-bidi-font-family: "Times New Roman"; mso-bidi-theme-font: minor-bidi"><br /></span></font></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><font size="3">Business Solutions Manager, SCM <br /></font></span></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><font size="3"><b><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: #9f0f30; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">North American Construction Group</span></b><b><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><br /></span></b></font></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><span style="mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><a href="
http://www.nacg.ca/"><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: blue"><font size="3">www.<b>nacg</b>.ca</font></span></a></span><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><br /></span></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><b><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><font size="3">P: (780) 960-2251<br /></font></span></b></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><font size="3"><b><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">C: (780) 721-1877</span></b><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><br /></span></font></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; FONT-SIZE: 10pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><br /></span><font size="3"><b><i><span style="FONT-FAMILY: "Bookman Old Style","serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes">‘Everyone Gets Home Safe’</span></i></b><b><i><span style="FONT-FAMILY: "Bookman Old Style","serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes; mso-bidi-font-family: "Times New Roman""><br /></span></i></b></font></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><span style="COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri"><span><font size="3" face="Calibri"> </font></span><br /></span></span><br /><p style="MARGIN: 0in 0in 0pt" class="MsoNormal"><span style="mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><a href="
http://www.everyonegetshomesafe.com/"><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: blue"><font size="3">www.<b>everyone</b>getshome<b>safe</b>.com</font></span></a></span><span style="FONT-FAMILY: "Arial","sans-serif"; COLOR: black; mso-fareast-font-family: "Times New Roman"; mso-fareast-theme-font: minor-fareast; mso-no-proof: yes"><br /></span></span><br />', '1', NULL);
java.sql.BatchUpdateException: Data truncation
at net.sourceforge.jtds.jdbc.JtdsStatement.executeBatch(JtdsStatement.java:901)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreTableData(RestoreSDBackup.java:728)
at com.adventnet.servicedesk.tools.RestoreSDBackup.restoreDatabase(RestoreSDBackup.java:391)
at com.adventnet.servicedesk.tools.RestoreSDBackup.main(RestoreSDBackup.java:116)
at com.adventnet.servicedesk.tools.RestoreDialog$5.run(RestoreDialog.java:188)
at java.lang.Thread.run(Thread.java:745)