Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Import taxonomy fields from Sharepoint Document library into SQL database

Posted on 2014-11-21
1
Medium Priority
?
154 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 1000 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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

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

When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

885 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