# Migrating to Workspaces

## Overview

This page describes the general process for migrating to SingleStore Helios.

Migration is typically performed by following the documented steps to:

* Prepare the target Helios deployment
* Back up or export existing databases and objects
* Restore or import the databases and objects into Helios
* Validate the migrated environment

The exact steps may vary depending on your source environment and migration goals.

## Migrate to Helios

The following table outlines the tasks that must be performed to migrate from a self-managed cluster or a non-SingleStore platform to Helios.

| Step | Task                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Self-Managed Cluster | Non-SingleStorePlatform |
| ---- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------- | ----------------------- |
| 1    | **Create an inventory**of all objects, databases, tables, records, functions, stored procedures, views, aggregations, pipelines, database variables, etc. in your current production environment that need to be migrated.                                                                                                                                                                                                                                                                                                                                                                                                                         | ✔                    | ✔                       |
| 2    | **Calculate the size**required to store all the existing objects and data. Refer to the[SingleStore Helios Sizing Guidelines](https://docs.singlestore.com/cloud/getting-started-with-singlestore-helios/singlestore-helios-sizing-guidelines.md)for more information.                                                                                                                                                                                                                                                                                                                                                                             | ✔                    | ✔                       |
| 3    | **Create test plans for the following**:*Connectivity*<ul> <li>Upstream / downstream dataflows</li> <li>Application</li> <li>End-user</li> </ul>*Functionality*<ul> <li>Data accuracy</li> <li>Custom objects</li> <li>Jobs</li> <li>Permissions</li> </ul>*Performance*<ul> <li>Ingest</li> <li>Query</li> <li>Skew</li> </ul>*Rollback*                                                                                                                                                                                                                                                                                                          | ✔                    | ✔                       |
| 4    | **Create theworkspacein theCloud Portal**Refer to[Compute Workspaces](https://docs.singlestore.com/cloud/getting-started-with-singlestore-helios/compute-workspaces.md)for more information.Ensure there are enough credits to create an appropriately sizedworkspace.                                                                                                                                                                                                                                                                                                                                                                             | ✔                    | ✔                       |
| 5    | **Generate SQL statements**that can be executed to reproduce all the required objects. Use a third-party tool such as`mysqldump`.Refer to[Transition from MySQL to SingleStore Helios](https://docs.singlestore.com/cloud/developer-resources/transition-from-mysql-to-singlestore-helios.md)for more information.                                                                                                                                                                                                                                                                                                                                 |                      | ✔                       |
| 6    | **Create the objects inSingleStore Helios**. Use the`.sql`dump file created in Step 5.Copy and paste the contents of this file into theSingleStore HeliosSQL Editorand run the SQL statements to recreate all objects in theworkspace.**Note**: While self-managedSingleStoreStudio does not work withworkspaces, you can use theCloud Portalorthird-party tools.                                                                                                                                                                                                                                                                                  |                      | ✔                       |
| 7    | **Back up**all of your databases. Use the[BACKUP DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/backup-database.md)command to back up the data in production or take a backup from daily backups.For non-SingleStoredatabases, refer to[Migrating Data from Another Database](https://docs.singlestore.com/cloud/developer-resources/guides/migrating-data-from-another-database.md)for more information.                                                                                                                                                                                               | ✔                    | ✔                       |
| 8    | **Restore the backed-up data to theworkspace**. Use the[RESTORE DATABASE](https://docs.singlestore.com/cloud/reference/sql-reference/operational-commands/restore-database.md)command to restore the database backups from the cloud object store into theworkspace.**Note**: If you are moving from aSingleStore Self-Managedcluster to aSingleStore Heliosworkspace, first copy the backup to the proper cloud service and then restore.For non-SingleStoredatabases, refer to[Migrating Data from Another Database](https://docs.singlestore.com/cloud/developer-resources/guides/migrating-data-from-another-database.md)for more information. | ✔                    | ✔                       |
| 9    | **Validate inventory and objects inSingleStore Helios**. Confirm that everything exists in theworkspaceenvironment. This should include everything gathered in Step 1.                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | ✔                    | ✔                       |
| 10   | **Add**users, groups, roles, permissions, resource governor pools, database variables, and global system variables settings by raising a[Support ticket](https://support.singlestore.com).                                                                                                                                                                                                                                                                                                                                                                                                                                                         | ✔                    | ✔                       |
| 11   | **Set the firewall rules**for the newworkspace. Refer to[Firewall](https://docs.singlestore.com/cloud/security/firewall.md)for more information.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | ✔                    | ✔                       |
| 12   | **Select the endpoint URL**. Theworkspacewill have a different endpoint URL than the prior cluster.Only DML endpoints are currently offered. The DDL can be provided if some operations require it. Refer to[SingleStore Helios Endpoints](https://docs.singlestore.com/cloud/connect-to-singlestore/singlestore-helios-endpoints.md)for more information.                                                                                                                                                                                                                                                                                         | ✔                    | ✔                       |
| 13   | **Perform application-level validation testing**. Connect your application and run benchmark queries.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | ✔                    | ✔                       |

***

Modified at: June 11, 2026

Source: [/cloud/getting-started-with-singlestore-helios/migrating-to-workspaces/](https://docs.singlestore.com/cloud/getting-started-with-singlestore-helios/migrating-to-workspaces/)

(An index of the documentation is available at /llms.txt)
