Forum Discussion
Solved
Sharepoint Online - Site backup / export
Hi What options do we currently have to export a Site in Sharepoint Online? Scenario is, need to export an existing Production site to reuse/import it to our testing environment under a differen...
- Third party tool is the best way to go...taking into account you might be exporting a small site in size, you could try to see if using a trial tool is enough for you even I recommend you to invest some money here (Sharegate and Metalogix are cood choices)
Hi, a bit late to the party but just run into the same problem recently and after research I did collect the list of possible solutions for SharePoint data back-up/archiving/exporting:
* Simply export data into Excel from SharePoint list view (no attachments, only metadata, wouldn't work for large lists, manual work required)
* Apply information management policies to a list (not available by default for SharePoint Online, limited destination optionality)
* Use Export-SPWeb SharePointServer cmdlet (works only for Sharepoint Server, wouldn't work for SharePoint Online)
* Create workflow (MS Flow) which can move the items from the List to a chosen destination (be aware 5000 search limitation is still there)
* Write PowerShell script and run is by Windows Task Scheduler (time consuming and, you know, PowerShell)
* Create a custom .NET Application using CSOM (.NET Framework required) and run it as a Windows Service (development is required)
* Create custom WEB application using SharePoint JavaScript Client Object Model or 3-rd party libraries like SharepointPlus
* If you have MS SQL Server you could create SQL Server Integration Services (SSIS) package, read list items as a OData source and run it as a job
* Use 3-rd party tools like https://github.com/listman-io/docs to automate lists data archiving and export by schedule with attachment. The app will work for large lists with no 5000 limitations.