# Moving Data Between Databases

There are ways to move your data between databases depending on whether SingleStore Helios or SingleStore Self-Managed is where the data is being accessed. 

* [SELECT ... INTO](https://docs.singlestore.com/cloud/reference/sql-reference/data-manipulation-language-dml/select/#select-into-variable.md) , [CREATE PIPELINE AS LOAD DATA](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/create-pipeline.md), then [START PIPELINE](https://docs.singlestore.com/cloud/reference/sql-reference/pipelines-commands/start-pipeline.md). The following example uses S3, but this will work for HDFS, GCS, KAFKS,   and AZURE as well.
  ```sql
  SELECT * FROM table_name_1
  INTO S3 bucket/target 
  CONFIG configuration_json 
  CREDENTIALS credentials_json 

  CREATE PIPELINE pipeline_name AS LOAD DATA S3 'bucket-name' | '<bucket-name/path>' 
        [CONFIG '<configuration_json>']
        CREDENTIALS '<credentials_json>'
  INTO TABLE table_name_2;         

  START PIPELINE pipeline_name;
  ```

***

Modified at: September 10, 2025

Source: [/cloud/manage-data/moving-data/moving-data-between-databases/](https://docs.singlestore.com/cloud/manage-data/moving-data/moving-data-between-databases/)

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