# Migrate a Local Storage Database to an Unlimited Storage Database

> **📝 Note**: Unlimited storage databases are not available in all editions of SingleStore. For more information, see [SingleStore Editions](https://docs.singlestore.com/db/v9.1/introduction/singlestore-editions.md).

Migrating a local storage database to an unlimited storage database requires two steps:

* Run the [BACKUP DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/backup-database.md) command to backup the local storage database.
* Run the [RESTORE DATABASE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/operational-commands/restore-database.md) to restore the database backed up in the first step into an unlimited storage database. 

## Example

In the following example, the local storage database `db` is migrated to an unlimited storage database. S3 is used as the remote object store, where `backup_bucket` is the S3 bucket containing the backup of the local storage database and `bottomless_bucket` is the S3 bucket containing the remote object store for the migrated database.

```sql
BACKUP DATABASE db TO S3 "backup_bucket/backup_folder"
  CONFIG '{"region":"us-east-1"}'
  CREDENTIALS '{"aws_access_key_id":"your_access_key_id","aws_secret_access_key":"your_secret_access_key"}';
```

```sql
RESTORE DATABASE db
   FROM S3 "backup_bucket/backup_folder"
   CONFIG '{"region":"us-east-1"}'
   CREDENTIALS '{"aws_access_key_id":"replace_with_your_access_key_id","aws_secret_access_key":"replace_with_your_secret_access_key"}'
   ON S3 "bottomless_bucket/bottomless_folder"
   CONFIG '{"region":"us-east-1"}'
   CREDENTIALS '{"aws_access_key_id":"replace_with_your_access_key_id","aws_secret_access_key":"replace_with_your_secret_access_key"}'
```

***

Modified at: August 6, 2025

Source: [/db/v9.1/manage-data/unlimited-data-storage/migrate-a-local-storage-database-to-an-unlimited-storage-database/](https://docs.singlestore.com/db/v9.1/manage-data/unlimited-data-storage/migrate-a-local-storage-database-to-an-unlimited-storage-database/)

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