Hello All,
We are running into an issue while trying to migrate data from CRM 2011 to CRM 365 On-prem starting with the lead entity. We are doing a direct upgrade, so far we have created the customizations by using the same schemas for all the custom entities/fields in question. We are using Kingswaysoft SSIS Integration toolkit. We added the CRM users in CRM 365 manually (AD lookup) so therefore their GUIDS are different than CRM 2011 GUIDS. We are doing the match as owneridname = ownerid and using the text look up set to Systemuser (fullname), also selected owneridtype = owneridtype. Since CRM 2011 naming convention for fullname is lastname, firstname and CRM 365 is firstname lastname therefore I believe it couldn't do the match and failing with an error = Attribute: ownerid cannot be set to NULL because it couldn't find a match and therefore couldn't do a Create/Upsert for the leads. We have to keep the ownership of the core entities in both the CRM version same.
We also tried changing the fullname as firstname lastname in CRM 2011 but it still couldn't find a match by text lookup. So what are my options here:
1) Create a mapping table in our SQL server that would contain the Source GUID and Target GUID and link it with the SSIS package as a lookup component. We can start working on it. Any blogs/webinar links that we can find useful?
2) Recreate the CRM users again with their original GUIDS after we remove them from CRM 365 (either by a hard delete, not recommended or a system restore from a backup). Is there a way we can bring in the users with the original GUIDS using any tool or utility or any other way?
Is there any other option or recommendations that we can follow?
Thanks!!
*This post is locked for comments
I have the same question (0)
