locked
Port documents from SPS 2003 to MOSS 2007 RRS feed

  • Question

  •  I have a new document library created in my moss 2007 site. I want to transfer all the documents from my old sps 2003 document library to my new moss 2007 document library.

    Anyone know an easy way to port my documents across, there are quite a lot of documents to port ??

    Thanks,
    J.
    Tuesday, February 17, 2009 3:48 PM

Answers

  • >You could just open up the document library in Explorer View for both SPS2003 and then for the document library in MOSS and >drag and drop between the two.  That'd be the easiest way to do things.

    That's part of the solution but it will only work to full satisfaction of the poster if he only has Office files in his document library (as they contain the properties in the file itself).

    For other types of files it is necessary to follow this up with a Datasheet View to Datasheet view copy (identical views in SPS 2003 and MOSS 2007 with the file name in the first column and all the fields included . sorted on the file name) of all the rest of the fields. Otherwise all the data in the fields of the SPS 2003 List are lost.

    There are some restrictions to that. Created/Modified/Created By and Modified By fields will not be transfered. Fields like Lookup or Calculate also not; and finally a bulk copy won't copy the contents of Multi-line fields.



    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
    • Marked as answer by Lu Zou-MSFT Monday, February 23, 2009 11:59 AM
    Tuesday, February 17, 2009 5:32 PM

All replies

  • You could just open up the document library in Explorer View for both SPS2003 and then for the document library in MOSS and drag and drop between the two.  That'd be the easiest way to do things.
    John
    SharePoint911: SharePoint Consulting
    Blog: http://www.rossonmoss.com
    Twitter: JohnRossJr

    MOSS Explained: An Information Workers Deep Dive into Microsoft Office SharePoint Server 2007
    Tuesday, February 17, 2009 4:36 PM
  • >You could just open up the document library in Explorer View for both SPS2003 and then for the document library in MOSS and >drag and drop between the two.  That'd be the easiest way to do things.

    That's part of the solution but it will only work to full satisfaction of the poster if he only has Office files in his document library (as they contain the properties in the file itself).

    For other types of files it is necessary to follow this up with a Datasheet View to Datasheet view copy (identical views in SPS 2003 and MOSS 2007 with the file name in the first column and all the fields included . sorted on the file name) of all the rest of the fields. Otherwise all the data in the fields of the SPS 2003 List are lost.

    There are some restrictions to that. Created/Modified/Created By and Modified By fields will not be transfered. Fields like Lookup or Calculate also not; and finally a bulk copy won't copy the contents of Multi-line fields.



    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
    • Marked as answer by Lu Zou-MSFT Monday, February 23, 2009 11:59 AM
    Tuesday, February 17, 2009 5:32 PM
  •  You would also loose versions using the explorer view to copy the documents.
    Sameer Dhoot
    My Blog : http://Sameer.Dhoot.in/ | http://Intellects.in/
    Tuesday, February 17, 2009 6:53 PM
  • ok everyone, thanks for the replies.

    John D. I tried copy over but it didn't work for me. The 2 document libraries are on different servers.

    Mike and Sameer, do you have any better way of doing this transfer ?

    I transfered documents from sps 2001 to sps 2003 and used a tool called spout.exe
    Is there any similar tool for transferring from sps 2003 to moss 2007 ??

    Thanks,
    J.

    Wednesday, February 18, 2009 10:18 AM
  • > John D. I tried copy over but it didn't work for me. The 2 document libraries are on different servers.

    I have done it between servers on different continents.

    Create a document library in MOSS with exactly the same specifications as your SPS 2003 one.

    Open explorer view in the two servers in two different browser copies.

    If drag and drop doesn't work then use Ctrl-C (old) and Ctrl-V (new)

    If that doesn't work then do it again only this time with a smaller number of files each time.

    If all fails, copy the documents to your hard disk and then upload them to the MOSS doc lib. This *shouldn't* be necessary.

    -------------

    There is no way round Sameer's comment other than programming or using the expensive migration tools from Tsunami and AvePoint etc.

    P.S. There is no free tool.

    WSS FAQ sites: WSS 2.0: http://wssv2faq.mindsharp.com WSS 3.0 and MOSS 2007: http://wssv3faq.mindsharp.com
    Total list of WSS 3.0 and MOSS 2007 Books (including foreign language titles) http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/V%20Books.aspx
    Wednesday, February 18, 2009 10:23 AM
  • Hi

     

    Mike is right.  if you want to write code to do the document library migration, you can use the Microsoft.SharePoint.Deployment Namespace to export and import the list.

    For more information, please refer to:

    http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.deployment.aspx

     

    Hope this helps.

     

    Lu Zou

     

     

    Friday, February 20, 2009 9:51 AM
  • We have used the MetaLogix tool and its pretty good and much cheaper than AvePoint... they are also good at providing support if somethings are broken or did not migrate correctly... we had issue using this tool for InfoPath libraries where it did not bring over the promoted columns and views... but as far as versions is concerned its was all there. The probelm was fixed by them.



    Sameer Dhoot
    My Blog : http://Sameer.Dhoot.in/ | http://Intellects.in/
    Friday, February 20, 2009 3:42 PM