'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Migrate File Server Batch Jobs to SharePoint Online
Question details
The user needs to automate the uploading of nightly batch files and database backups from an on-premises file server to SharePoint Online.
- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Migrating automated local network backups to cloud storage seamlessly.
- Observed behavior
- Seeking a secure method to continuously and automatically transfer files from a local file server to a SharePoint document library without manual intervention.
Ensure you have Microsoft Power Automate access and administrative privileges on the on-premises file server to install and configure the required data gateway.
Use Power Automate with an On-Premises Data Gateway
Deploying a data gateway bridges your local network with Power Automate, allowing secure and scheduled file transfers directly to SharePoint.
The on-premises data gateway acts as a secure bridge, providing quick data transfer between on-premises data and various Microsoft cloud services. By combining this with Power Automate, you can schedule nightly flows to upload your batch jobs to SharePoint without manual intervention.
Download and install the on-premises data gateway on your local file server from the Microsoft Power Automate portal, then sign in with your Microsoft 365 credentials.
Sign in to Power Automate, navigate to 'Create' in the left menu, and select 'Scheduled cloud flow'. Configure the frequency to match your nightly backup schedule.
Add a new step and search for the 'File System' connector. Configure it using your newly installed on-premises data gateway to securely access your local network folder.
Add the 'SharePoint - Create file' action. Select your target SharePoint site and define the destination document library where the backup files will be saved.
Manage Migrated Documents with WPS Office
As you migrate your server files to the cloud, consider WPS Office as a free, lightweight, and highly compatible alternative to Microsoft Office. It seamlessly handles Word, Excel, and PowerPoint files natively, ensuring your team can access and edit migrated documents effortlessly.
- 1. Install WPS Office: Download and install WPS Office Free from the official website to your local machine.
- 2. Access Migrated Files: Sync your SharePoint document library to your computer or download the migrated files directly.
- 3. Edit Seamlessly: Open your DOCX, XLSX, or PPTX files directly in WPS Office to edit, save, and collaborate without format compatibility issues.
Frequently Asked Questions
What is an on-premises data gateway?
An on-premises data gateway is a software application that facilitates secure data transfer between your local network servers and Microsoft cloud services like Power Automate, Power Apps, and Power BI.
Can Power Automate handle very large database backups?
Power Automate has file size limits depending on your license and the specific connector used. For extremely large database backups (e.g., several gigabytes), you may need to utilize Azure Data Factory or Azure Storage Explorer instead.
How do I monitor if the nightly batch upload failed?
You can configure your Power Automate flow to send an email notification or a Microsoft Teams message automatically if the 'Create file' action fails during its scheduled run.
Is it possible to delete the local file after uploading it to SharePoint?
Yes. You can add a 'File System - Delete file' action at the end of your Power Automate flow to remove the local file once the SharePoint upload is confirmed successful.
