I want to copy/move a large document library of over 100,000 documents items in around 3000 document sets, from one site to another. The sites are within the same Sharepoint: name.sharepoint.com but the document libraries are not within the same site.
I want to use one of these 3 options:
1) Create a Document Library as a template without content and move the thousands of documents from the initial library to the new one using the 'Send To' option. The problem with this is that it only works 1 item at a time, and since there are thousands of documents, this is not an option.
2) Create a Document Library as a template including the content. The problem with this is the option that includes content is grayed out.
3) From the Office 365 Admin Panel - Sharepoint Admin Centre in the records management section, you can define a 'Send to connection'. So I created a new one called it 'Invoices' and selected the action as 'Copy'. I obtained the destination link from the Content Organizer Settings of the new site, which looks like this:
When going in one of the document sets that I want to move and trying to copy an item using this new 'Send to Connection', I am getting this error: 'was not configured as a publication location for this location'
What should I look for in any of the options? I don't mind which one to use, though the second one would seem neater. Also, I wouldn't mind being directed into any type of code or workflow method that can achieve this, if Sharepoint doesn't already offer such functionality.