SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

we have a 2007 farm that we are rebuilding in 2010. I want to take advantage of some of the new feature like Managed Metadata and I was wondering if there were any good tools out there that can migrate from a text type field to a Taxonomy or Lookup field?

Many thanks

share|improve this question

I have not seen a specific tool that does this, but my approach would be to define the new field and then create a powershell script that would iterate the items and move the data from source to destination field.

The field could be defined in the powershell if needed.

The challenge with this approach is that the update would be logged so all records would be showing as recently being modified by the user running the update. This would also be a challenge with lists or libraries with workflows that execute on edit.

Far from perfect, but it is a solution.

share|improve this answer
up vote 0 down vote accepted

I found some code to transfer lists between two enviroments in this blog - seems to work ok.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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