Move files between document libraries in the same Site Collection

Question

I have a need to move ~10,000 files from one document library to another in the same site collection. I believe that powershell is the best means for doing this.

I found the following article: http://blog.isaacblum.com/2011/10/04/spfilecollection-class-copy-files-to-another-document-library/#respond that suggested a means for doing this however I'm unsure how to adapt this script (I'm getting my first exposure to Powershell with this project).

I tried the following to no avail:

$PSSnapin = Add-PsSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue | Out-Null
clear

$org = "hhttp://farm/sitecollection/Document Library Source/Forms/AllItems.aspx"
$dest = "hhttp://farm/sitecollection/Document Library Destination/Forms/AllItems.aspx"

$orgLibrary = (Get-SPWeb $org).Folders["Documents"]
$destLibrary = (Get-SPWeb $dest).Folders["Documents"]
$destFiles = $destLibrary.Files
foreach ($file in $orgLibrary.Files)
{
    $curFile = $file.OpenBinary()
    $destURL = $destFiles.Folder.Url + "/" + $file.Name
    $destFiles.Add($destURL, $curFile, $true)
}

Is there an alternate way of doing this? Note that I'm using MOSS2007 and Powershell 2.0, not SharePoint 2010.

Update / Semi-Answer:

As per x0n's post below this isn't supported in SharePoint 2007 (only 2010). I recevied the following advice outside of this thread, which is pertinent, and should help others in future:

Unfortunately SharePoint 2010's Management Shell (it's PowerShell snap-in and associated cmdlets) is not compatible with MOSS 2007 and there aren't cmdlets available directly from Microsoft for that version of SharePoint. What that means is that you can still use PowerShell with MOSS 2007, but you're either going to have to write your own cmdlets that use STSADM or the SharePoint Object Model directly, or you're going to have to use MOSS 2007-compatible cmdlets from a third party. I'd suggest checking out Gary Lapointe's blog for a lot of great PowerShell cmdlets for MOSS 2007 (http://blog.falchionconsulting.com/), or places where people upload cmdlets such as CodePlex.com, the TechNet Script Repository, POSHCode.org, or http://get-spscripts.com/.

Solution

I'm not surprised you're getting nowhere: The Microsoft.SharePoint.PowerShell snapin is for SharePoint 2010 only, and isn't available on a SharePoint 2007 server.

Frankly, the easiest way to do this is to open Internet Explorer, navigate to the source document library and open the "explorer view." Select all documents, and copy (ctrl+c). Open another IE window and do the same thing for the target document library and paste (ctrl+v).

If it won't open in explorer view, ensure that the machine you're using to do the copy/paste has the "WebClient" service running. If you're running Windows 2008 R2, this service is not available unless you decide to add the "desktop experience" feature. It's a lot easier to find a Windows 7 machine instead, which will have the WebClient service (but be sure it's running.)

Update:

That said, your script is probably about 80% there and doesn't really need that 2010 snapin. I can't test this right now (sorry) but it should be about 99% correct:

[reflection.assembly]::loadwithpartialname("microsoft.sharepoint") > $null

$org = "http://farm/sitecollection/sourcedoclib" 
$dest = "http://farm/sitecollection/targetdoclib" 

$site = new-object microsoft.sharepoint.spsite $org
$web = $site.openweb()

$srcLibrary = $web.Lists["sourcedoclib"] 
$destLibrary = $web.Lists["targetdoclib"] 

$destFiles = $destLibrary.Folders["Archived"]

foreach ($item in $srcLibrary.Items) 
{ 
   if ($item.File) {
        $curFile = $item.file.OpenBinary() 
        $destURL = $destFiles.Folder.Url + "/" + $item.file.Name 
        $destFiles.Add($destURL, $curFile, $true)
    }
} 

Good luck.

Comments

[Michael A]

That's how we've done this previously but unfortunately this is a recurring process and likely to spread across 30+ document libraries by the end of the month - is there a PowerShell library for MOSS that we could use to accomplish the above?

[x0n]

You shouldn't have to modify your script that much to get it to work on 2007 anyway. Let me take a look at it.

[Michael A]

I tried to implement this but I'm receiving the following for each file in the library (and it's not moving), any ideas? Error is: You cannot call a method on a null-valued expression. At line:20 char:23 + $destFiles.Add <<<< ($destURL, $curFile, $true) + CategoryInfo : InvalidOperation: (Add:String) [], RuntimeException + FullyQualifiedErrorId : InvokeMethodOnNull