Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Import taxonomy fields from Sharepoint Document library into SQL database

Posted on 2014-11-21
1
130 Views
Last Modified: 2015-04-29
I have a document library on my Sharepoint 2013 site with various properties, where some of them are of the type Managed Metadata, taxonomy.
I need to import those items and all of their properties into sql database.
I tried to use the Odata source to import the data from the sharepoint document  library, but none of the managed metadata columns seems to be imported. How could I achive this?
0
Comment
Question by:gosi75
1 Comment
 
LVL 18

Accepted Solution

by:
Simon earned 500 total points
ID: 40471063
Looks like it might be a struggle :(

You've probably seen these links already if you've Googled the issue...
http://msdn.microsoft.com/en-us/library/office/hh147179%28v=office.14%29.aspx
https://gallery.technet.microsoft.com/office/ExportImport-the-Taxonomy-b41dfddb
http://underthehood.ironworks.com/2011/10/sharepoint-2010-how-to-backuprestore-managed-metadata-from-one-farmenvironment-to-another.html

Sorry, I can't help beyond providing the links above. The last link included a comment that suggested a code-free way of migrating the metadata to another farm.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL Update query with connected table data 3 37
Forcing check-in on SharePoint 2010 4 28
Re-appearing SQL Server Agent jobs 7 28
SQL R 21 25
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question