Heroku Postgres Migration Tools

PostgreSQL cloud database migration and synchronization

Migrate and synchronize data between Heroku Postgres, cloud platforms, and on-premises databases with DBConvert and DBSync tools for PostgreSQL-powered applications.

Both directions
Migrate in and out of Heroku Postgres
Cross-engine
MySQL, SQL Server, Oracle → Postgres
DBSync
Scheduled, repeatable sync

Why Choose DBConvert for Heroku Postgres Migration?

Heroku Postgres is a managed PostgreSQL service, so application teams run on Postgres without managing the database servers.

Heroku Postgres's own tools (pg:backups, pg_dump) move Postgres to Postgres only - other engines need a separate step. DBConvert is a single desktop tool that works both directions: load MySQL, SQL Server, Oracle, Access, FoxPro, and more into Heroku Postgres with type mapping, schema, and keys handled - and export it back out to on-prem PostgreSQL or another engine. DBSync adds scheduled, repeatable sync for phased cutovers.

PostgreSQL-Compatible Connection Model

Connect DBConvert or DBSync to a Heroku Postgres database with the standard PostgreSQL connection details - see PostgreSQL migration tools for engine-specific workflows.

Start your Heroku Postgres migration

Pick your other database - each converter runs both ways, into Heroku Postgres or back out. Free trial, Windows.

MySQL ↔ Heroku Postgres SQL Server ↔ Heroku Postgres Oracle ↔ Heroku Postgres PostgreSQL ↔ Heroku Postgres

Each download converts both ways. More sources + DBSync below.

What DBConvert Handles on a Heroku Migration

Cross-engine conversion in both directions, with scheduled sync - in one desktop tool.

Cross-engine type mapping

Maps MySQL, SQL Server, and Oracle data types to PostgreSQL equivalents so tables land cleanly in Heroku Postgres.

Schema, indexes, and keys

Recreates tables, primary and foreign keys, and supported indexes - not just raw rows.

Both directions

Load data into Heroku Postgres, or export it back to on-prem PostgreSQL or another engine.

Scheduled sync

DBSync keeps Heroku and a source database aligned during a phased cutover, not a one-time copy.

Standard PostgreSQL connection

Connects over the Heroku Postgres connection details - a normal Postgres connection, no special setup.

Reusable jobs

Save a migration and re-run it as the dataset changes or you stage the move in steps.

Heroku Postgres Migration Directions

Start from the matching PostgreSQL-compatible converter for your source engine.

MySQL

MySQL to Heroku Postgres

Migrate MySQL-family data into Heroku Postgres.

Download converter
Ongoing sync? Get DBSync · Details
SQL Server

SQL Server to Heroku Postgres

Convert Microsoft SQL Server data into Heroku Postgres, with type mapping handled.

Download converter
Ongoing sync? Get DBSync · Details
Oracle

Oracle to Heroku Postgres

Migrate Oracle data into Heroku Postgres, including schema and keys.

Download converter
Ongoing sync? Get DBSync · Details
PostgreSQL

PostgreSQL ↔ Heroku Postgres (same engine)

Move an existing PostgreSQL database into Heroku Postgres - or export it back out. Handled by DBConvert Studio.

Download DBConvert Studio
About Studio

Supported Database Platforms

Migrate data between Heroku Postgres and the database engines commonly used in app stacks.

PostgreSQL

PostgreSQL Family

  • PostgreSQL
  • AWS RDS/Aurora
  • Google Cloud SQL
  • Azure Database
SQL Server

Microsoft SQL Server

  • SQL Server
  • Azure SQL Database
  • Azure SQL Data Warehouse
  • Cloud SQL for SQL Server
Oracle

Oracle & Others

  • Oracle and Oracle Cloud
  • MySQL and MariaDB
  • Microsoft Access
  • Amazon RDS

Configuration Guide & Resources

Use the Heroku Postgres connection guide or contact support for help selecting the right migration path.

Heroku PostgreSQL Configuration

Connect DBConvert tools to a PostgreSQL database running in a Heroku environment.

Read Configuration Guide

Need Expert Help?

Contact support if your Heroku migration includes several source engines, staged deployment, or sync requirements.

Contact Support
DBConvert Streams

Need log-based, real-time replication?

DBConvert Streams is a separate product for continuous, log-based change data capture. DBConvert and DBSync tools on this page cover conversion, scheduled sync, and trigger-based sync workflows.

See Streams

Ready to Migrate to Heroku Postgres?

Start your migration into or out of Heroku Postgres with the PostgreSQL-compatible DBConvert and DBSync tools.

Get PostgreSQL Migration Tools Contact Support