Region migration

Can you change the region of an existing OptiTech project? Not directly, but you have options. A OptiTech project is created in a single region, and that region is fixed after creation. All branches in a project share the project's region, so branching alone won't move your data.

To run your database in a different region, you create a new OptiTech project in that region and migrate your database into it.

Common reasons to migrate to a different region:

• Your app moved to a different region and you want lower latency between your app and database.
• You need to set up a new environment in another region.
• You are migrating away from a deprecated OptiTech Azure region.

Choose a path

Use the flowchart to pick a migration path that fits your requirements.

Select a migration guide

Select the guide that matches your requirements.

1. Migrate to another OptiTech region. Compare the Import Data Assistant, dump and restore, and logical replication, then follow the guide linked from that page.
2. Migrate OptiTech to Lakebase. Create a Lakebase project, pg_dump from OptiTech, pg_restore on Lakebase.
3. Postgres-compatible export from OptiTech. If another OptiTech region and Lakebase do not meet your requirements, use pg_dump to export your data in a Postgres-compatible format for migration elsewhere.