SharePoint Online to Google Drive Migration Guide

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:

  1. Purchase Licenses.
  2. Create a Customer.
  3. Apply Licenses.
  4. Review Considerations.
Purchase Licenses Create a Customer Apply Licenses Considerations

Purchase licenses by following the steps below:

  1. Sign in to your BitTitan account. 
  2. In the top navigation bar, click Purchase.
  3. Click the Select button and choose User Migration Bundle licenses.
  4. Enter the number of licenses you want to purchase. Click Buy Now.
  5. Enter a Billing address if applicable.
  6. Click Next.
  7. Review the Order Summary and enter a payment method.
  8. Click Place Your Order.

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. 

Prepare Source Environment

Sharepoint Online Endpoint

Prepare the destination environment by following the steps below:

  1. Create the SharePoint site and make a note of the site URL where the document libraries are stored.
  2. 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.
  3. 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.

Delegated Authentication App-Based Authentication

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.

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

  1. 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.
  2. Enter a project name and click Create.

 Step 2: Enable APIs for Service Account

  1. Click Menu > APIs & Services > Library, from the Google Cloud Platform Console.
  2. 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

  1. Click Menu > IAM & Admin > Service accounts, from the Google Cloud Platform Console.
  2. Click Create Service Account and enter a name.
  3. Click Create.
  4. Assign the role of Owner to the new Service Account by selecting Owner from the Role drop-down menu.
  5. Click Done.
  6. You will now be returned to the "Service Accounts" page. 
  7. On the ‘Service accounts' page, click the vertical ellipsis under the 'Actions’ column for the service account created above.
  8. Click + Add Key.
  9. Click Create New Key.
  10. Make sure that JSON is selected as "Key Type."
  11. Click Create.
  12. 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:

  1. Click Menu
  2. Click IAM & Admin
  3. Click Service Accounts
  4. Find the service account set up in Step 3: Create a Customer Tenant Account.
  5. 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.
  6. You will now have one of two options, depending on if the Google UI has been updated in your tenant.

Old Google Tenant

  1. Go to the G Suite admin page at admin.google.com
  2. Click on Security.
  3. Click on Advanced Settings
  4. Click Manage API Client Access.

Otherwise, if your account shows the latest UI updates from Google, as shown, follow the steps below.mceclip0.png

  1. Go to the G Suite admin page at admin.google.com
  2. Click on Security.
  3. Click Advanced Settings.
  4. Under ‘Domain-wide delegation’, click Manage domain-wide delegation.
  5. 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: 

  1. In the Client ID field, paste the Unique ID copied above.
  2. 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
  3. 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.

  1. Log in to MigrationWiz.
  2. Click the Go to My Projects button.
  3. Click the Create Project button.
  4. Select the Document project type. 
  5. Click Next Step.
  6. Enter a Project name and select a Customer.
  7. Click Next Step.
  8. 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 a Source Endpoint

  1. Click Endpoints.
  2. Click Add Endpoint.
  3. Select SharePoint.
  4. Enter the URL for the top-level SharePoint document library, i.e., the site URL.  
  5. Enter the administrator username and password in the fields.

    Important

    This must be either a Global administrator, SharePoint Online administrator, or a Site Collection administrator account.
  6. Click Add Endpoint. 

Create a Destination Endpoint

  1. Click Endpoints.
  2. Click Add Endpoint.
  3. Select Google Drive (Own Service Account)
  4. Click Select File.

  5. Select the JSON file that contains the Google Service Account key, saved during the service account setup process.

  6. Enter the Google admin account email address and domain name in the appropriate fields. Please note that this admin email should match the end-user domain.

  7. Click Add Endpoint.

Add Users

For this migration, we suggest using the Quick Add option. To do so, follow the next steps.

  1. Click the Add New Items list drop-down.
  2. Click Quick Add.
  3. Under Source, write down the source library name in the field provided. 
  4. Under Destination, enter the name of the Google Drive account to migrate this library.
  5. 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

  1. Select the users.
  2. Click the Start button from the top.
  3. Select Full Migration.
  4. 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.

Was this article helpful?
0 out of 1 found this helpful