Migrate to another OptiTech region

You can't change the region of an existing OptiTech project in place. A project's region is fixed when you create it. To move your database to a different region, you create a new OptiTech project in the target region and migrate your data into it, then cut over and delete the old project.

Choose a migration method

Each option below is a different way to move your database into a new OptiTech project in a different region. Choose the option that matches your requirements.

Import Data Assistant

Best for smaller databases (roughly under 10 GB) and when you want a guided flow in the OptiTech Console.

In the OptiTech Console, open the Projects page and start the Import Data Assistant. The assistant creates your new OptiTech project in the target region as part of the same flow. You begin by entering the connection string for the database you are migrating from. See Import Data Assistant for instructions.

pg_dump and pg_restore

Best for when you want full control of dump files and restore timing. See Migrate data from another OptiTech project.

Logical replication

Best for minimal downtime on busy databases where a long dump or restore window is not acceptable.

You replicate from the source project to the target and cut over when caught up. See Replicate data from one OptiTech project to another. Expect more configuration than other migration methods.

Related docs

• Region migration
• Get started with logical replication