Well, it's been a while since I blogged about anything, but I've got what is hopefully going to be a good one here. I've got a small SPS 2003 to MOSS 2007 migration project to help with over the next week or two and one aspect of the project is the need to move some documents from an SPS 2003 document library to a MOSS 2007 document library. Generally this would be part of an upgrade process, but our client already has a MOSS 2007 farm deployed and in use and wants to slowly build out additional MOSS 2007 sites and site collections and move the documents from their old SPS 2003 server.

I know there are a couple of ways to do this such as using the Explorer View and then Copy or Cut from one location and Past to another location, but I wanted a way to do this where I could script it out and do a couple of dry runs over the course of a week or two and then do a final cut-over one evening (the SPS 2003 farm is still in use so documents are being added and changed on a daily basis). So, I've written a command line utility called MOSSadm.exe which does the following:

• Copies a document library from an SPS 2003 site (via Web Service calls) to a MOSS 2007 document library
• Exports a document library from an SPS 2003 (via Web Service calls) to a ZIP file
• Exports a document library from a MOSS 2007 site (via the object model) to a ZIP file
• Imports a ZIP file to a MOSS 2007 document library (via the object model)

I've packaged this all up into a simple setup program which can be DOWNLOAD HERE. Once downloaded, run the Setup.exe program to install the application on your MOSS 2007 Farm. When you run the setup, the following is done (I included this because I always like to know what's going on when I run a setup program):

• The following files are put in the 12 Hive bin directory:
  • MOSSadm.exe
  • ICSharpCode.SharpZipLib.dll (complements of ic#code… see http://www.icsharpcode.net/OpenSource/SharpZipLib/)
• The following files are put in the C:\Program Files\Statera\MOSSadm_Setup\WSDL Files directory:
  • DocService.asmx
  • DocServicedisco.aspx
  • DocSerevicewsdl.aspx
  • Document03Service.dll
  • Readme.txt

If you want to use the web service calls to download documents from an SPS 2003 server, you'll need to go read the Readme.txt file installed in the previous step. This tells you what files to copy out to your SPS 2003 server and where to put them in order to install the web service).

Now… as long as the 12 Hive bin directory is in your path, just open up a command prompt and type mossadm.exe. You should get the following:

As the help text in the screenshot above shows you, there are 4 operations you can run (note the * next to the first two… those make use of the SPS 2003 Web Services). If you enter in an operation, such as mossadm –o copydoclib then you'll get additional help text such as:

You're all set and ready to start using this utility. Here are some sample commands you can now use:

• mossadm –o copydoclib http://www.mySps2003Svr.com "Some Doc Lib" bsmith mydomain pass@word1 http://www.myMoss2007Svr.com "Documents"
• mossadm –o exportdoclibfromwebsvc http://www.mySps2003Svr.com "Some Doc Lib" bsmith mydomain pass@word1 MyDocumentLibrary.zip
• mossadm –o exportdoclib http://www.mySps2003Svr.com "Some Doc Lib MyDocumentLibrary.zip
• mossadm –o importdoclib MyDocumentLibrary.zip http://www.myMoss2007Svr.com "Documents"

Additionally, you can specify a new folder within a document library to put everything such as:

• mossadm –o importdoclib MyDocumentLibrary.zip http://www.myMoss2007Svr.com "Documents/a new folder"
• mossadm –o importdoclib MyDocumentLibrary.zip http://www.myMoss2007Svr.com "Documents/a new folder/myDocs"

If you have any problems, please feel free to drop me a note and I'll let you know if I have a solution (please include your email address so I can get back to you easily).

Couple Notes:

• This utility copies some document properties, but not all of them. It also doesn't copy past versions and it marks the document at the destination location with your name as the creator.
• When you run the utility you must be on the MOSS 2007 server and it'll be best if you're logged in as a site administrator of the site you're interacting with.

Download Code: click here