PostgreSQL to MySQL Migration

SQLines tools can help you transfer data, convert database schema (DDL), views, stored functions (procedures), triggers, queries and SQL scripts from PostgreSQL to MySQL.

Databases:

  • PostgreSQL 14.x, 13.x, 12.x, 11.x, 10.x and 9.x
  • MySQL 8.x and 5.x

Migration Reference

Technical information on migration from PostgreSQL to MySQL.

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

PostgreSQL MySQL
1 GENERATED AS IDENTITY Identity column AUTO_INCREMENT