MySQL to PostgreSQL migration

Events happening in the community are now at Drupal community events on www.drupal.org.
tunic's picture

Migrating a MySQL Drupal to PostgreSQL

After several hours of uncertainty it seems that I have managed to migrate a MySQL Drupal to a PostgreSQL. So I want to share my experience with this group where I think could be useful.

There are several problemas to solve: table structure translation, autoincrement values / sequences, serialized data, etc.

I've tried several ways, but always I came up against some problem.

Database schema

MySQL and PostgreSQL use different data types for its columns, they define its tables in its own way, you can't use MySQl definitions.

Read more
Subscribe with RSS Syndicate content