locked
Move sharepoint 2010 list to 2013 with lookup columns RRS feed

  • Question

  • Hi all,

    Iam planning to move my sharepoint 2010 list to 2013.I done this using save site as template.But the look up columns are showing empty data.Can u please let me know the best solution to do this.

    Regards,

    Praveen

    Monday, April 13, 2015 8:38 AM

Answers

  • Hello Praveen,

    When you save list as template the look up columns will fail because the List GUIDs will change.

    http://blog.johnsworkshop.net/moving-lists-with-lookup-columns-inside-your-site-collection/

    https://social.technet.microsoft.com/Forums/sharepoint/en-US/a0cc6051-99da-48d4-b041-e2e3239c775e/how-to-take-list-backup-with-lookup-columns-data-in-sharepoint-2010?forum=sharepointadmin

    If you are migrating the site then the recommended approach is to move the content database over to the new SharePoint 2013 farm.

    https://social.technet.microsoft.com/forums/sharepoint/en-US/c7d657c7-9f2e-4629-9b8c-ffac54e59689/migration-of-one-site-to-sharepoint-2013



    My Blog- http://www.sharepoint-journey.com|
    If a post answers your question, please click Mark As Answer on that post and Vote as Helpful

    • Marked as answer by IndulHassan Monday, April 13, 2015 2:33 PM
    Monday, April 13, 2015 8:54 AM

All replies

  • Hello Praveen,

    When you save list as template the look up columns will fail because the List GUIDs will change.

    http://blog.johnsworkshop.net/moving-lists-with-lookup-columns-inside-your-site-collection/

    https://social.technet.microsoft.com/Forums/sharepoint/en-US/a0cc6051-99da-48d4-b041-e2e3239c775e/how-to-take-list-backup-with-lookup-columns-data-in-sharepoint-2010?forum=sharepointadmin

    If you are migrating the site then the recommended approach is to move the content database over to the new SharePoint 2013 farm.

    https://social.technet.microsoft.com/forums/sharepoint/en-US/c7d657c7-9f2e-4629-9b8c-ffac54e59689/migration-of-one-site-to-sharepoint-2013



    My Blog- http://www.sharepoint-journey.com|
    If a post answers your question, please click Mark As Answer on that post and Vote as Helpful

    • Marked as answer by IndulHassan Monday, April 13, 2015 2:33 PM
    Monday, April 13, 2015 8:54 AM
  • The reason the lookup column doesn’t work anymore in your SharePoint 2013 list is because Save Site as Template, preserve all the list settings. Therefore, the lookup column still points to the original list which was located on your SharePoint 2010 list. The lookup column stores GUID of the web, list, and the field to which it points and GUID are unique IDs that identifies a list/library/site/feature in a farm.

    Using SharePoint Manager you can find the LookupList, LookupWebId and LookupField of your old SharePoint 2010 lookup column and compare it with your new 2013 lookup column. You will see the difference.

    There are two approach to get your values in lookup again.

    1(a). Create a new list and update the lookup values.
    1(b). Delete the lookup column and create a new lookup column and point it to the new list created in the above point.

    2. Update the SchemaXml property of the lookup column through SharePoint Manager.

    I will provide you with a good reference on how to use SharePoint Manager while managing your lookup columns. http://blog.johnsworkshop.net/moving-lists-with-lookup-columns-inside-your-site-collection/


    Please remember to click 'Mark as Answer' and Vote as Helpful if the reply answers your query.


    Monday, April 13, 2015 9:03 AM