Solved

Sharepoint list to document library conversion

Posted on 2010-11-08
5
1,988 Views
Last Modified: 2012-05-10
Is it possible to convert a List to Document Library in MOSS 2007?

I am working on upgrading a WSS v2 site to MOSS 2007, but having issues with explaining to the management that converting (if it's even possible) is going to be time consuming, and difficult.

The WSS v2 site has been growing wildly for the past couple of years with no supervision. Now that performance is declining, there is a sudden rush to migrate to MOSS 2007. The problem is the WSS v2 site is about 69gb in size, and one of the lists has about 176,000 items. I have urged the business owner to clean up the site, but that is not an option.

The business has read that large lists are still not supported in MOSS 2007, and using a document library will solve our size issue. But a conversion does not seem possible since the content types will be from a different base.

Cheers,
Brendan
0
Comment
Question by:brendanlefavre
  • 2
  • 2
5 Comments
 
LVL 21

Expert Comment

by:chapmanjw
Comment Utility
Document libraries and lists in SharePoint 2007 are the same thing when it comes to how SharePoint stores and interacts with them from the database.  Because of that, the 2000 item suggested limit applies to both document libraries and lists.

Unless you want to be able to interact with documents they way they are in document libraries vs using attachments, you aren't going to see much difference between keeping the list format and converting it to a document library.

There isn't anyway to simply convert a list with attachments to a document library with the meta data from the list attached to it.  You would have to do this manually.
0
 
LVL 6

Accepted Solution

by:
einarbrown earned 500 total points
Comment Utility
Maybe you should take the step to Sharepoint 2010 which handles large lists better.
0
 

Author Comment

by:brendanlefavre
Comment Utility
SharePoint 2010 is our ultimate goal, but it's my understanding that there is no direct path from SharePoint 2003 to SharePoint 2010 without a custom migration tool. I have attempted a DB Attach upgrade from 2003 to 2007, but due to the large size of the database the upgrade was not successful. It ran for 36+ hours on a 24 processor server with 48gb of RAM. My guess is that if i let it run long enough it would eventuall finish.

I am still working on a buy-in that if properly configured we can make a large list work. Is there a script that I can run that will take x number of items, and move them to a folder?

Cheers,
Brendan
0
 
LVL 21

Expert Comment

by:chapmanjw
Comment Utility
I would re-attempt the 2003 to 2007 upgrade of the content database.  I have had instances where it took 2 or 3 tries.

I am not aware of any 2003 scripts that will let you export list items like that.
0
 

Author Closing Comment

by:brendanlefavre
Comment Utility
we created a new SharePoint 2010 site, and started with a fresh dataset. The SharePoint 2003 site was placed in a read-only state.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 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

9 Experts available now in Live!

Get 1:1 Help Now