Solved

Migrating SharePoint List Data between SharePoint instances using SSIS

Posted on 2014-10-29
1
167 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

776 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