Sharepoint 2010 Term Store migration

Before you answer, yes I have googled it and yes I've tried the first 200 examples!

I have 2 sp2010 farms, DEV and TEST
I have a site collection in DEV that has a library that has had a column created by doing...

Create column, Name it, set it as Managed Metadata AND THEN selecting Customize your term set.

Now in Term Store Management Tool you can see something like the following....
Term store manager
If i now use ANY of the documented ways to migrate the metadata from DEV to TEST, i get the SYSTEM metadata transfered fine but no sign at all of the Site Collection data..

Any thoughts.
LVL 37
Neil RussellTechnical Development LeadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I have to ask : Have you tried copying your DEV Managed Metadata DB from the DEV SQL Srv to the Test SQL Srv, and then connect your TEST Managed Metadata Service App to the "new" DB? (Make sure your managed metadata service account has perms to the DB in test!)
Neil RussellTechnical Development LeadAuthor Commented:
Yes and the site collectioin that is transfered with a content deployment job does not see those Term Sets.
Thats odd - that the exact method that works for me in our production environment which also publishes an entire site collection via content deployment.
when you restored the termstore DB, is this the process you used?

1. Backup the managed metadata database in your source farm
2. Delete the MMS service in your target farm
3. Restore the managed metadata database to your target farm
4. Create a new MMS service in your target farm
5. Ensure correct service accounts have full control of MMS
6. Rename the properties of the SQL database to be the name of original db (if your MMS database names are not the same on each environment)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Neil RussellTechnical Development LeadAuthor Commented:
I'll run through the whole process from scratch again tomorrow and let you know.
Neil RussellTechnical Development LeadAuthor Commented:
Yup, we must have missed something along the way I guess
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.