article thumbnail

Database migration from MySQL to PostgreSQL

Galido

In general, database migration consists of the following steps: Extract table definitions from the source database in form of DDL SQL statements. Convert these statements into the destination format and load into the target database. Export data from the source database into an intermediate storage (for example, csv files).