Migrating a MySQL Drupal to PostgreSQL
Posted by tunic on June 25, 2012 at 6:37pm
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