Thank you Trevor for your timely reply. We were able to resolve the above specified issue by Altering the Collation, removing the foreign key constraints and were able to upgrade from kentico 7.0.26 to 8.0 using the tool.
After completion as instructed by the kentico upgrade instructions we have compared the original files with the .new files and merged the custom changes/replaced the new files with the existing files accordingly (Please find the attached screenshot below)
But while building the new project(after upgrade), we are getting issues related to dll reference like the following:
1. 'EcommerceFunctions' does not contain a definition for 'GetProductImage'
2. Element 'CMSEditModeButtonEditDelete' is not a known element
3. The type 'Global' is defined in an assembly that is not referenced. You must add a reference to assembly 'App_Code.3qahivsw, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null'.
4. The name 'GetAttachmentIconUrl' does not exist in the current context.
These issues occurs in multiple files in the solution. like - \CMS\CMSVirtualFiles\Transformations\CMS.Root\AttachmentLightboxDetail.ascx.
Tried referring the the API changes - https://devnet.kentico.com/documentation/api-changes/kentico-8 to fix the build errors , fixed few but still not able to compile the solution without errors.
Is there a reason why is the Kentcio upgrade tool not replacing the API realated changes to the upgraded solution or Are we missing any steps?
Can you please provide your suggestion on this ?
Thanks in advance.