I have a subsite (and a document library in the subsite) that I need to migrate from development to testing. However, the lookup columns are defined differently in test (as well as in production). When I export from dev and import the site into test, the document library does not display correctly unless I delete all the lookup columns. Is it possible for me to change the definitions of the lookup columns in development to match test (and later change to match production) before migration?

I really wish I do not have to delete the lookup columns because it would require about 70+ document library views to be reconfigured with the appropriate column filters.


  • How are you migrating? OOTB I've never seen lookup columns carry over properly. I've always had to recreate them. They sometimes work when we use DocAve to migrate lists, as long as the lists and columns are identical.
    – Erin L
    Jul 14, 2016 at 22:58
  • I've tried exporting/importing using just the template (.WSP) as well as using the power shell commands Export-SPWeb and Import-SPWeb with the (.CMP) content migration package files. The dev environment and it's lookup columns also don't match what our company has in production, so ideally, if I can just change what I currently have to what I need to migrate to, it would be nice. I essentially have 70+ views that sort by document type that I need to transfer over correctly.
    – Starwater
    Jul 14, 2016 at 23:10

1 Answer 1


Another workaround is to take the complete site backup. Then restore it in Production as a different site. Then use Content And Structure to move the libraries to proper place.

  • Would it be possible to then copy over the documents in production and keep their column attributes/values?
    – Starwater
    Jul 15, 2016 at 0:46
  • Yes. You have lot of flexibility by using Content and Structure options. Jul 15, 2016 at 0:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.