Solved

Import taxonomy fields from Sharepoint Document library into SQL database

Posted on 2014-11-21
1
139 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
[X]
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
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
connection to SQL 2012 error in windows 10 18 49
rolling count by date, hour query 7 31
T-SQL: Wrong Result 7 39
SQL - Using an 'array' kind of variable 5 19
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

751 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