Install the databases

Next, install the MySQL and CouchDB databases. You can install the databases manually or using the command line.

The databases serve different purposes and both are required when you set up Google Workspace Migrate. The CouchDB database stores the detailed logging for each transaction. The MySQL database stores all the links between objects for configuration and logging purposes. It also stores the mappings between migrated objects in the source and target environments. 

Before you begin

• Copy the database installers that you downloaded in the previous step to the Microsoft Windows servers where you plan to install each database.
• Keep your Windows servers updated, but we recommend turning off automatic updates during a migration so the process isn't interrupted.
• Ensure the data directory disks have sufficient space. For details, see System requirements.
• MySQL needs a dedicated server or VM instance to run. Multiple databases cannot run from the same server.
• If you upgrade the databases, you will get a new password. When the upgrade is complete, update the Google Workspace Migrate database settings with the new password.

Install MySQL database

Expand section  |  Collapse all & go to top

Option 1: Install MySQL manually

On the Windows server:

1. Run GoogleWorkspaceMigrate_MySQL_Installer as an administrator.
2. Accept the license agreement and click Next.
3. Choose a location for the MySQL installation and click Next.
4. Choose a location for the MySQL data directory and click Next.

   MySQL stores all database information in the data directory.

5. (Optional) Specify a PFX file to configure TLS and click Next.

   This step is not required. You can just click Next. 

6. Take note of the database credentials.

   Important: Make sure you store the credentials securely. You'll need them when you set up the platform. They might also be required for debugging purposes.

7. Click NextInstall.
8. When the installation is complete, click Finish.

Record the host name or internal IP address of this Windows server. You’ll need it in a later step.

Option 2: Install MySQL using the command line

On the Windows server:

1. Run PowerShell as an administrator.
2. Enter GoogleWorkspaceMigrate_MySQL_Installer.exe /ROOTPASSWORD= RootPassword /ADMINPASSWORD=MigrateUserPassword and any additional parameters (details below). 

   Example:

   GoogleWorkspaceMigrate_MySQL_Installer.exe /ROOTPASSWORD=RootPassword /ADMINPASSWORD=MigrateUserPassword /SP- /VERYSILENT /SUPPRESSMSGBOXES /NORESTART

3. For Destination Location, click Browse, navigate to the folder where you want to install MySQL, and click Next.
4. For MySQL Data Directory, click Browse, navigate to the folder where you want to install the data directory, and click Next.
5. Take note of the database credentials.

   Important: Make sure you store the credentials securely. You'll need them when you set up the platform. They might also be required for debugging purposes.

Command-line parameters

For more details on the command-line parameters available, consult the documentation for Inno Setup.

Parameter	Description
/ADMINPASSWORD	Sets the password for the migrate user
/NORESTART	(Optional) Prevents a system restart during installation
/ROOTPASSWORD	Sets the root password for MySQL
/SP-	(Optional) Turns off prompts at the beginning of a setup
/SUPPRESSMSGBOXES	(Optional) Suppresses all message boxes
/VERYSILENT	(Optional) Turns off the setup wizard and windows during the installation process

For more details on the command-line parameters available, consult the documentation for Inno Setup.

Install CouchDB

Expand section  |  Collapse all & go to top

Option 1: Install CouchDB manually

On the Windows server:

1. Run GoogleWorkspaceMigrate_CouchDB_Installer as an administrator.
2. Accept the license agreement and click Next.
3. Choose a location for the CouchDB installation and click Next.
4. Choose a location for the CouchDB data directory and click Next.

   CouchDB stores all database information in the data directory.

5. (Optional) Specify a PFX file to configure TLS and click Next.

   This step is not required. You can just click Next. 

6. Take note of the database credentials.

   Important: Make sure you store the credentials securely. You'll need them when you set up the platform. They might also be required for debugging purposes.

7. Click NextInstall.
8. When the installation is complete, click Finish.

Note: Record the host name or internal IP address of this Windows server. You’ll need it in a later step.

Option 2: Install CouchDB using the command line

When you install from the command line, the installer automatically chooses these locations for the CouchDB installation and data directory:

• C:\CouchDB
• C:\CouchDB_data

On the Windows server:

1. Run PowerShell as administrator.
2. Enter GoogleWorkspaceMigrate_CouchDB_Installer.exe /ADMINPASSWORD=MigrateUserPassword and any additional parameters (details below).

   Example:

   GoogleWorkspaceMigrate_CouchDB_Installer.exe /ADMINPASSWORD=MigrateUserPassword /SP- /VERYSILENT /SUPPRESSMSGBOXES /NORESTART

3. Take note of the database credentials.

   Important: Make sure you store the credentials securely. You'll need them when you set up the platform. They might also be required for debugging purposes.

Command-line parameters

For more details on the command-line parameters available, consult the documentation for Inno Setup.

Parameter	Description
/ADMINPASSWORD	Sets the password for the migrate user
/SP-	(Optional) Turns off prompts at the beginning of a setup.
/NORESTART	(Optional) Prevents a system restart during installation.
/SUPPRESSMSGBOXES	(Optional) Suppresses all message boxes.
/VERYSILENT	(Optional) Turns off the setup wizard and windows during the installation process.

Next step

Install & set up the platform

_{Google, Google Workspace, and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.}