Solved

Migrating SharePoint List Data between SharePoint instances using SSIS

Posted on 2014-10-29
1
165 Views
Last Modified: 2016-02-11
Hi All,  I have a business requirement to migrate SharePoint List data from one SharePoint instance to another SharePoint instance. (Lists are not in the same Site Collection/Web App, but completely separate instance).  I've been experimenting with SSIS and the Source and Destination adapters on Code Plex and I think I'm very close.  However, there are a few important columns that are not coming over properly and that is the SharePoint "Choice" column type with "Checkboxes (allow multiple selections)".

As you could imagine the data in those columns cover over, but not properly even when the destination column is also a lookup with the same options.  It looks something like this when multiple selections are in a single column: 2, OptionA, 1, OptionB

I have basic experience with SP Designer and SSIS and am more on the Admin side, not development.  I realize this wouldn't be fully supported by Microsoft, but we do need to migrate this data somehow.

Any help is much appreciated. Thanks!
0
Comment
Question by:polaris101
1 Comment
 
LVL 15

Accepted Solution

by:
colly92002 earned 500 total points
ID: 40412294
Is this SharePoint 2010?   If so, the SSIS module on Codeplex is really more useful to extract data from SP into SQL.

If this is a one-of copy, I would recommend you simply save the list as a template and tick the box to include the data, then create a new list using the created file as a template on your destination.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
These days socially coordinated efforts have turned into a critical requirement for enterprises.
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

919 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now