SharePoint Online Scripts to Copy A Library w/ Metadata to Another Doc Library

Question

I'm fairly new to Powershell for SharePoint and have a run a few small scripts.

I was attempting to use this script to copy one library and its contents to another empty library. I couldn't do save as template because the library is too large.

https://blogs.msdn.microsoft.com/rcormier/2012/11/16/how-to-copy-sharepoint-documents-between-site-collections-using-powershell/

Is this script too old or just not compatible with SharePoint Online? I keep getting the " this cmdlet is not recognized

Any help or advice on this would be greatly appreciated or reference to some others scripts.

I am looking to copy the library, it's files and metadata.

Answer 1

There are couple of options to copy files to new library

Synch and Copy You can sync both libraries to local drive and copy. This doesn`t require any coding.

1. Sync source library
2. Sync destination library
3. Copy files and folders from source to the destination from your synced folders.

Note: It is not copying metadata

Use PnP PowerShell

It requires primary knowledge on PnP scripts and needs to setup PnP files on your local system.

You can copy file and metadata using your custom PowerShell script.

Refer the following link

Setup PnP PowerShell

Video to get started on copying files

Create Console Application

It requires C# knowledge to create small copy function and execute from your system. I will explain further if you are interested this way.

Answer 2

Just want to add to Venkat's sync and copy option. Assuming you are very familiar with SharePoint designer and all the file names or Title names are unique and there are no folders, you could use a workflow to copy the metadata over to the new library.

• create the new library to be identical as the old library including all the metadata columns

• create a workflow on the new library to start when an item is created. In the workflow, add actions to set field values using values gotten from the old library. In those actions, filter by the file name or Title column

• then sync both libraries to your computer

• then copy files from the old library to the new one

• after some minutes, all the metadata will be copied over

• you can then delete the workflow on the new library

Answer 3

I saved the Source Document Library as a template with out the content included. Saving the template made sure that I had all columns and views.

After creating and adding the template to the site I wanted, I used "Site Content and Structure" under Site Settings to Copy the files over to the newly created Target Document Library. It also kept all the meta data. It wasn't a huge library, about 250 files.