This is the complete onboarding guide for migrating documents from SharePoint Online to Google Drive. This migration type is known as "many to one", which means that data belonging to many users is being migrated into a single account.
First migration?
We’ve created a guide on scoping, planning, and managing the migration process for your use. If this is your first migration, we recommend reading this guide carefully.
MigrationWiz
MigrationWiz is a migration tool, not a syncing tool. If changes are made at the source after migration, they will not sync to the destination, nor will changes made at the destination sync to the source. We do not have “live” monitoring of changes (as with a sync agent) and we cannot handle scenarios such as conflict resolution without user interaction.
MigrationWiz supports the capability to share migration projects across a Workgroup. When the Project Sharing feature is turned on, all Agents besides those who are Inactive can view all migrations projects.
Prerequisites
Licensing
We recommend that you purchase User Migration Bundle licenses for this migration scenario. User Migration Bundle licenses allow the performance of multiple migrations with a single license. For questions on licensing, visit MigrationWiz Licenses.
To use your license by following the next steps:
- Purchase Licenses.
- Create a Customer.
- Apply Licenses.
- Review Considerations.
Purchase licenses by following the steps below:
- Sign in to your BitTitan account.
- In the top navigation bar, click Purchase.
- Click the Select button and choose User Migration Bundle licenses.
- Enter the number of licenses you want to purchase. Click Buy Now.
- Enter a Billing address if applicable.
- Click Next.
- Review the Order Summary and enter a payment method.
- Click Place Your Order.
Create Customer on MSPComplete by performing these steps:
- Click the Add button in the top navigation bar
- Click the Add Customer button on the All Customers page
- Select the appropriate workgroup in the left navigation pane and click All Customers.
- Click Add Customer.
- Enter the new customer’s information in the Add Customer form. Primary Email Domain and Company Name are required. The rest are optional.
- Click Save.
- Repeat steps 1 through 4 for each customer you want to add.
Perform these steps on MSPComplete:
- Select the correct workgroup on the top of the left navigation pane.
Important
This is the workgroup which the customer and migration projects were created under. Your account must be part of the workgroup if the project was not created under your account. - Click Customers on the left navigation pane.
- Click the customer that employs the user to whom you want to use the User Migration Bundle license.
- Click the Users tab at the top of the page.
- Apply the license to the users by checking the box to the left of their emails.
- Click the Apply User Migration Bundle License button at the top of the page.
Tip
We recommend adding users to the Customer page with the vanity domain. Then apply the User Migration Bundle Licenses, before editing to show the .onmicrosoft domain, if the .onmicrosoft domain will be used for the migration. - Click Confirm if at least one unassigned User Migration Bundle license is available for each selected user.
Important
If there are no User Migration Bundle licenses currently available to be assigned and your role in the workgroup is Manager or higher, the form that appears provides all the necessary information and will walk you through the steps of purchasing User Migration Bundle licenses.
Licenses are released once payment has been received:
- Licenses are available immediately upon payment if you purchase via credit card.
- If you purchase via wire transfer (100+ licenses), the licenses will be available once payment is received and accepted.
- We do not accept purchase orders because of processing overhead.
In both cases, you will be notified by email that payment has been accepted and licenses are available in your account upon notification.
For more information on licensing, including coupon redemption and other licensing types, see our Licensing FAQ.
Limitations
Please consider the following limitations for SharePoint Online to Google Drive migrations.
- We are not able to support migrations with two-factor or multifactor authentication.
- App password usage, MFA/2FA, and ADFS are not supported for the migration admin account/service account being used by this endpoint.
Prepare Source Environment
Sharepoint Online Endpoint
Prepare the destination environment by following the steps below:
- Create the SharePoint site and make a note of the site URL where the document libraries are stored.
- Create the document libraries on the destination SharePoint Online site (optional). To learn how to create it, follow the steps from Microsoft: Create your document library.
- Ensure all necessary users/groups (including external users, if any) are set up at the SharePoint site and available for your destination document library.
Application Permissions for SharePoint
Continue configuring your destination environment by selecting one of these application permissions options and following the steps to enable permission levels at the destination.
The easiest approach is to use the global administrator account set up at the time of tenant creation. However, if you do not wish to use this global admin account during migration, then a new user account can be created instead. This user account needs to have a license assigned that includes SharePoint and be granted Site Collection Administrator privileges to the SharePoint site in the project.
- Create a user in Microsoft 365 and assign a license that includes SharePoint. For step-by-step instructions, see the Microsoft article Add users individually or in bulk to Office 365.
- Set the administration privileges. Grant one of the permission levels listed below to the user account to be user as the administrator for the endpoint in the project.
- Global Admin. Microsoft has instructions to set these permissions here: Assign admin roles.
- SharePoint Admin. For specific permissions and project settings to be used with a Site Collection Administrator, see MigrationWiz Permission Requirements.
- Add the admin account, created in step 2, as a Site Collection Admin to the endpoint.
Important
The Global Admin or SharePoint Admin role does not automatically grant Site Collection Administrator rights to a SharePoint site. - Go to MigrationWiz-SharePoint-Delegated and consent to the app access when prompted. Once you click on Accept, you will be redirected to the BitTitan login page. This is normal and the page can be closed.
BitTitan uses app-based authentication for SharePoint, providing greater security and reducing the potential of Microsoft throttling. It replaces the previous Microsoft 365 authentication, which has been subject to increased throttling by Microsoft. This app-based authentication method is specific for Microsoft 365 tenants.
- Ensure you are signed in as a Global Admin.
-
Go to MigrationWiz-SharePoint-FullControl and consent to the app access when prompted.
- Create a new Security Group named “MigrationWiz” on the Office 365 Admin Portal.
- Create a new user that is not having data migrated in the project. This account does not require any administrator roles to be assigned. If you already have an existing user, that should be fine. This user must have a SharePoint license applied.
- Add the new (or existing) user to the previously created security group as a Member. Adding it as an Owner does not work here.
- Create MigrationWiz project.
- When creating the source and destination endpoints, enter the user credentials in step 4 that correspond with the endpoint to which the user belongs.
-
Add the support option UseApplicationPermission=1 to the advanced options of the MigrationWiz project under Support Options.
Prepare Destination Environment
Google Drive (Own Service Account) Endpoint
This endpoint requires your tenant service account to be set up and Google APIs to be enabled. Follow the steps below to set up your environment for this endpoint.
Prerequisites
- Subscription to Google Cloud Platform.
- Google Super Administrator account.
- Ability to set up a service account on the G Suite tenant.
- The service account must be set up before the MigrationWiz project is created.
Step 1: Create a Google Project
- Go to the Google Cloud Platform (GCP) Console and sign in as a super administrator. Choose one of the options below:
- If you haven't used the Google Cloud Platform Console before, agree to the Terms of Service and click Create Project.
- If you have used Google Cloud Platform Console before, at the top of the screen next to your most recent project name, click Down to open your projects list. Then, click New Project.
- Enter a project name and click Create.
Step 2: Enable APIs for Service Account
- Click Menu > APIs & Services > Library, from the Google Cloud Platform Console.
- Enable the following APIs by selecting the specific API and clicking Enable.
Repeat for each API listed below:- Google Drive API
- Admin SDK
Make sure that the respective services are enabled within the Google tenant. You can control services for your users using the instructions on this page: Control who can access G Suite and Google Services.
Step 3: Create a Customer Tenant Service Account
- Click Menu > IAM & Admin > Service accounts, from the Google Cloud Platform Console.
- Click Create Service Account and enter a name.
- Click Create.
- Assign the role of Owner to the new Service Account by selecting Owner from the Role drop-down menu.
- Click Done.
- You will now be returned to the "Service Accounts" page.
- On the ‘Service accounts' page, click the vertical ellipsis under the 'Actions’ column for the service account created above.
- Click + Add Key.
- Click Create New Key.
- Make sure that JSON is selected as "Key Type."
- Click Create.
- Click Close.
- Make sure that you download the key as a JSON file and make a note of the name and location of the file. This JSON file will be used when setting up the migration endpoint in the Mailbox Migration project.
- The JSON file must contain information in the following fields: “type”, “private key”, and “client email”. If these mandatory fields are empty the file upload during endpoint creation will fail.
Step 4: Setting the Scopes for the Migration
From the Google Cloud Platform Console:
- Click Menu
- Click IAM & Admin
- Click Service Accounts
- Find the service account set up in Step 3: Create a Customer Tenant Account.
- Find the Unique ID field for that service account by clicking the Column Display Options button in the upper right corner above Actions and copy the ID number. The Client ID number will be used in the next steps.
- This field often needs to be added to the view. Click on the Column display options button and add a checkmark to Unique ID, then click OK.
- This Client ID should be considered similar to Administrator account passwords and handled securely.
- Go to the G Suite admin page at admin.google.com
- Click on Security.
- Click Advanced Settings.
- Under ‘Domain-wide delegation’, click Manage domain-wide delegation.
- Click Add new on the Manage domain-wide delegation page.
Step 5: Final Steps
Once these steps are complete, return to MigrationWiz for the following steps:
- In the Client ID field, paste the Unique ID copied above.
In the OAuth scopes (comma-delimited) field, paste all scopes listed below:
For destination endpoint (must include read-write scopes):
https://www.googleapis.com/auth/admin.directory.group, https://www.googleapis.com/auth/admin.directory.user, https://www.googleapis.com/auth/admin.directory.group.readonly, https://www.googleapis.com/auth/admin.directory.user.readonly,
https://www.googleapis.com/auth/drive - Click Authorize.
You should now see your specific Unique ID and the associate scopes listed.
MigrationWiz Steps
Create a Document Project
Document migrations will maintain the folder hierarchy from the source to the destination.
- Log in to MigrationWiz.
- Click the Go to My Projects button.
- Click the Create Project button.
- Select the Document Project type.
- Click Next Step.
- Enter a Project name and select a Customer.
- Click Next Step.
- Select endpoints or follow the steps below to create new endpoints.
Endpoints
Endpoints are now created through MigrationWiz, rather than through MSPComplete. The steps for this section outline how to create the endpoints in MigrationWiz.
If you select an existing endpoint, remember that only ten endpoints will show in the drop-down. If you have more than ten, you may need to search. Endpoint search is case and character-specific. For example, Cust0mer will not show up if the search is customer. We recommend keeping a list of endpoints you have created, along with any unique spellings or capitalization you may have used.
You may either use existing endpoints or create new ones.
Create your source endpoint by following the next steps:
- Click New.
- Select an endpoint name.
- Choose the SharePoint endpoint type.
- Enter the URL for the top-level SharePoint document library, that is the site URL.
- Enter the administrator username and password in the proper fields.
Important
This must be either a Global administrator, SharePoint Online administrator, or a Site Collection administrator account. - Click Add.
Create your destination endpoint by following the next steps:
- Click New.
- Select an endpoint name.
- Choose the Google Drive (Own Service Account) endpoint type.
-
Click Select File.
-
Select the JSON file that contains the Google Service Account key, saved during the service account setup process.
-
Enter the Google super admin account email address and domain name in the appropriate fields. Please note that this admin email should match the end-user domain.
- Click Add.
Add Users
For this migration, we suggest using the Quick Add option. To do so, follow the next steps.
- Click the Add New Items list drop-down.
- Click Quick Add.
- Under Source, write down the source library name in the field provided.
- Under Destination, enter the name of the Google Drive account to migrate this library.
- Click Save Item And Close.
Important
When setting your source information, keep in mind the following points up next:
- This does not require the whole URL, just the name of the library. The name that needs to be entered under the library field for both Source and Destination will be the text at the end of the site URLs.
- This field is case-sensitive.
- This may be different from the current name that has been set for the Document Library. The examples below help explain this:
- If the document library is named "Documents" and the URL is listed as "xxxxxx.sharepoint.com/Documents/", enter Documents as the document library name.
- If your document library is named "Documents" but the URL says "xxxxxx.sharepoint.com/Shared Documents/", the name of the document library that needs to be entered is Shared Documents.
Advanced Options
There are no specific recommended advanced options for this migration scenario. However, if you wish to apply folder mapping or filters, follow the steps below. This step is optional and only required if certain directories under a library need to be migrated into Google Drive accounts.
Support Tab
The following advanced options should be considered for this type of migration.
- FolderMapping="^My Drive->My Drive/DestinationFolder" This advanced option creates a directory on the Destination Google Drive account and migrates the files into that directory. You should replace "SourceFolder" and "DestinationFolder" with the names of the folders in the Source and Destination environments.
- ShouldConvertToDestinationFormat=1 MigrationWiz converts the Microsoft file types (".doc", ".docx", ".ppt", ".pptx", ".xls", ".xlsx") into Google file types (Google Docs, Google Sheets, Google Slides), where possible. The file conversions do not happen by default.
Long-term projects
It may be necessary to add an Advanced Option during the final migration pass to verify the contents of previously migrated items if the migration project is a long-term project, for more information contact Support.
Run the Migration
Turn down permissions before migrating. If permissions are left checked, this will result in errors during your migration, because permissions should not be migrated for this scenario.
Full pass
- Select the users.
- Click the Start button from the top.
- Select Full Migration.
- Click Start Migration.
Run Retry Errors
Look through the user list and click any red "failed migration" errors. Review the information and act accordingly.
If problems persist contact Support.
Request Statistics
Click the pie chart icon in the MigrationWiz dashboard to receive an email containing all the project migration statistics.
Post Migration
Prevent users from inadvertently using the Source SharePoint libraries and decommissioning the Source SharePoint server, libraries, or user accounts.