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

Managed Metadata terms and termset each have a unique guid. In this scenario, take a backup of a production site that is using managed metadata in some columns in a list. Now restore this site into another environment. The guids don't match up, therefore you have to go through and reclick each term and "wire it back up" so it's okay and doesn't show in red text.

I've written a utility that will go through each list, checks the terms text, finds that test in the term set, then resets the guid accordingly.

But there has to be a better way. What am I missing? (By not using a third party pay tool)

share|improve this question
up vote 4 down vote accepted

The by far easieast way to move the MMS between environment is to use a backup->restore approach.

  1. remove the MMS SA from your destination farm
  2. restore the db to your destination sql
  3. create new MMS SA using the restored db name
  4. Voila
share|improve this answer
I wish SharePoint had the flexibility to backup/restore just areas of the term set, instead of the entire thing, but this approach should work. I do like Erick's export/import with guids approach and the tips in Neil's blog as well. I'm using sections of all three. – Shane Feb 9 '11 at 12:50
There are a few more steps than just these. MS has a decent article link. It includes stopping the MM service first. – JakeJacobsen May 19 at 14:59

The Cleverworkarounds blog has some tips worth checking out and a script you can use (which sounds like your approach). I know of a better way. Remember it's a v1.0 feature from Microsoft and so there's lots of work left to do (lots of bugs too).

There's also the (free) SolidIQ Managed Metadata Exporter which can get you part of the way.

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.