7 minute read
EFSS to Microsoft 365 Migration

Migrate from Dropbox to SharePoint Using Sharegate

One connector that Sharegate does not have yet is one to migrate from Dropbox to SharePoint or OneDrive. Therefore, we had to come up with an unorthodox way of bringing Dropbox content to the file system, then migrate it into SPO. The challenge here is to download all the content from Dropbox users. If there are only one or two users, it can be done manually but think when there are hundreds or thousands of users. When looking for solutions, we found a tool “Dropbox Business Admin Tool” in GitHub, which can be used to mass download user’s data.


Where to begin and what to consider before migration?

  • Communication is key to any migration. Be sure to let your users know a month in advance that there is a migration project from Dropbox to SharePoint. Follow it up with T-1 week and T-1 day notifications. Users should avoid making changes to files during the transition.
  • Plan out your migration waves. If you are migrating TB of data, it will take some time, so break it up into small “waves” to minimize support calls and downtime.
  • Think about how to prioritize your files – whether they’re active files or older backups. The active files have more business impact if delayed, so make sure to prioritize them for the smallest downtime window.
  • Make sure the servers/computers have enough space to download from Dropbox, stage, and then upload to OneDrive or SharePoint. A rule of thumb we use is there should be 1.5x the size of what you are trying to move
  • Identify and plan for external sharing requirements. If files need to be shared with outside organization, its recommend having a dedicated site collection in SharePoint, with enable external sharing and migrate them.
  • Plan for file versions. When downloading the Dropbox files file systems will lose all version documents and metadata information. Make sure users are aware of this through FAQs and standard communications.
  • User mapping should be defined manually from Sharegate tool.
  • Make sure to run an inventory report on your Dropbox files and analyse your files as below
    • Total Size
      • If total size of files is more that the storage capacity that you have on SharePoint, you need to increase the site collection space quota or buy additional storage (SPO).
      • If total size is huge (e.g. 1TB), Try to divide the file share content over multiple site collections when it concerns content which needs to be shared with others.
      • If certain content is just for personal use, try to migrate that specific content into the personal site of the user.
      • Its recommend moving data in batches. Try starting the process overnight or over a weekend when your team is less likely to need access to their files.
    • No of files
      • Make sure no folder has more than 5000 files.
      • If there are 5000 files, try to divide that amount over multiple subfolders or create additional views that will limit the number of documents displayed.
    • Largest file sizes
      • Make sure maximum size per file is not more than 2 Gigabyte and there are any you can’t migrate these
    • Deep folder structures nested
      • Make sure the nested folder structure total length should not cross more than 260 characters
    • Clean Up/prioritize your files
      • Clean up any files that are not necessary or not being used anymore
      • prioritize your files – whether they’re active files or older backups – for migration.

Migrate from Dropbox using Dropbox Business Admin Tool and ShareGate

Generate File Access and Manage Access tokens using a Dropbox admin account.
Migrate from Dropbox to SharePoint Using Sharegate
  • Select following options show in below screen for creating files access token
Migrate from Dropbox to SharePoint Using Sharegate
  • One you click on Create App it will create an API app form where you can generate Access Tokens
  • You must have to create an API App for manage access token similar way we did in step 3 where you need to select Team Member Management option.
  • Once you created an apps it will show as below in MyApps tab.
Migrate from Dropbox to SharePoint Using Sharegate
  • Click on each app and generate the respective token as shown below.
Migrate from Dropbox to SharePoint Using Sharegate
  • Note these tokens to provide in tool settings and click on Apply & Restart as shown below.
Migrate from Dropbox to SharePoint Using Sharegate
Download the content from DropBox
  • Now that the tool is configured, you can go to the tab “Download User Contents”
Migrate from Dropbox to SharePoint Using Sharegate

It will show all users in Dropbox.

  • Right click on a user a Click on List Files and it will show all contents for that user.
Migrate from Dropbox to SharePoint Using Sharegate
  • Select all files and provide Output Directory and click on “Dump Files” button.
Migrate from Dropbox to SharePoint Using Sharegate

Migrate download files to SharePoint Online using Sharegate

  • Open Sharegate, a Migration menu on left panel à select “Import from File Share” as shown below.
Migrate from Dropbox to SharePoint Using Sharegate
  • Provide destination contention as SharePoint Online link where content to be moved.
  • Select the document library you wanted to move the Dropbox files and click next.
Migrate from Dropbox to SharePoint Using Sharegate
  • It will open below screen and locate the Dropbox files where you download. For e.g. as below in G drive.
Migrate from Dropbox to SharePoint Using Sharegate

Note: Before copy, please make sure to map the users in destination.

  • Click on Mapping button as shown on the screen.
Migrate from Dropbox to SharePoint Using Sharegate
  • Since the files are on local machine, the files will be under login user. In below case the login ID is part of BUILTIN\administrator and that is the reason it searched in left source people and drag to source in the middle part in same way for target.

Remember here the target you should find the Dropbox user to which you are migrating and find the user and drag to destination in the middle part. Now the mapping part completed.

Migrate from Dropbox to SharePoint Using Sharegate
  • Click on Save button.
  • Select files from source and copy either drop to target location on right side or click on “Copy Now” button. This way it will migrate the all content to SPO.
Migrate from Dropbox to SharePoint Using Sharegate

Post migration considerations

  • Promote Collaboration – Users should be guided on co-authoring i.e., allowing two users to simultaneously work on a document may seem basic, this feature can drastically improve the way that users create and edit documents.
  • Enable External Collaboration –One of the most exciting features of SharePoint Online is that users can collaborate with external partners, vendors, consultants, and customers. External sharing can also be done in Office applications such as Word, Excel, or PowerPoint.
  • Create View on libraries wherever applicable if avoid the list/library threshold limits that were not present in Dropbox.
Seshavalli Pullipati

About Seshavalli Pullipati

Seshavalli has around 11 years of extensive Software Application Development, Production and Application Support (L2 and L3) experience in Microsoft Technologies. Also Having 7+ years of experience of SharePoint Administration in 2013/2010/2007 and 5 + years’ experience in K2 Smart Forms and Workflows, SharePoint Designer 2010/2007, InfoPath 2010, ASP.NET, Web Services ,SQL Server, .NET Framework, C#.NET, VB.NET, ASP.NET,ASP.Net WEB API’s, ADO.Net, JavaScript, XML and HTML. In addition, he is conversant with Crystal Reports , Oracle, Applix CRM Tool and SQL Tuning. Prior to joining Netwoven, he was working with ETISALAT Telecom Corporation, Bangalore as Technical Lead.

Seshavalli did his B.Sc (Computer Science) and M.Sc (Computer Science) from Sri Krishna Devaraya University, Andhra Pradesh in the year 2002 and 2004 respectively.

A native of Nandyal, Kurnool, Andhra Pradesh, he is presently living in Bangalore for the past 4 years. During his leisure time, he enjoys long drive, comic movies and spending time with his family. He takes special interest in Painting and Poetry.


3 replies on “Migrate from Dropbox to SharePoint Using Sharegate”

Sorry, it is working on windows 10 , i tried on windows server. But can we download files using same structure ?

you should generate both tokens and provide in tool and you should have Admin console permission in dropbox..if you still get any error send me the screen shot of each step

Leave a Reply

Your email address will not be published. Required fields are marked *

Enter Captcha Here :