Migrate the whole database
Every MySQL table becomes a PostgreSQL table in one run.
AUTO_INCREMENTbecomes an identity column, not a plain integer- Start here when the PostgreSQL schema does not exist yet
Withdata DBCopier - Secure, Fast, and Cross-Platform Tool for MySQL to PostgreSQL Data Transfer

Eight operations, one dialog. The first three move a whole database or one table, the next two take many tables, the last three decide the types, keep the two sides in step, or run the job for you.
Every MySQL table becomes a PostgreSQL table in one run.
AUTO_INCREMENT becomes an identity column, not a plain integerOne table in, one PostgreSQL table out.
public or a schema you mapExport the rows a SELECT returns, not the whole table.
LIMIT run on the MySQL sideMany tables, one pass.
One table per month or branch becomes one PostgreSQL table.
Six definitions decide whether the copy is still usable.
ENUM/SET become text plus a CHECK constraintunsigned loses only its range; DATETIME → timestampKeep PostgreSQL current without re-exporting.
Run it on a timer.
.bat or .shSix things decide whether the copy is still usable afterwards. Each is a column definition or a server setting, not a data value:
serial or an identity column (GENERATED BY DEFAULT AS IDENTITY). Copied as plain text it lands as integer NOT NULL with no default, and the next insert fails.CHECK constraint, a domain or a lookup table, and that constraint is not part of the data.WHERE name = 'abc' starts returning a different set of rows after the move.0000-00-00) do not exist in PostgreSQL; convert them to NULL before inserting.The four routes (pgloader, dump and rewrite, CSV in the middle, connect both databases), the three things that actually break, and how to verify the copy instead of just the row count: MySQL to PostgreSQL: Four Routes, and What Breaks.
| MySQL | PostgreSQL |
|---|---|
INT | integer |
BIGINT | bigint |
DECIMAL(p,s) | numeric(p,s) |
DOUBLE | double precision |
VARCHAR(n) | varchar(n) |
LONGTEXT | text |
DATE | date |
DATETIME | timestamp |
LONGBLOB | bytea |
TINYINT(1) | boolean |
JSON | jsonb |
Get the full version Withdata DBCopier for your operating system and start seamless MySQL to PostgreSQL data transfer
$129 one-time · volume discounts to $99 · 30-day money-back · pricing & licence terms · PostgreSQL to MySQL →