# Migrating Sakila from MySQL to PostgreSQL

DevFeed: [Migrating Sakila from MySQL to PostgreSQL](<https://devfeed.tech/articles/migrating-sakila-from-mysql-to-postgresql-34530.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2013/11/migrating-sakila-from-mysql-to-postgresql/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2013-11-12T10:37:00Z

Content type: tutorial

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Database](<https://devfeed.tech/topics/database.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [array](<https://devfeed.tech/tags/array.md>), [conference](<https://devfeed.tech/tags/conference.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [database](<https://devfeed.tech/tags/database.md>), [enum](<https://devfeed.tech/tags/enum.md>), [indexes](<https://devfeed.tech/tags/indexes.md>), [migrate](<https://devfeed.tech/tags/migrate.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [stored-procedures](<https://devfeed.tech/tags/stored-procedures.md>), [types](<https://devfeed.tech/tags/types.md>)

## AI overview

This tutorial demonstrates migrating the Sakila example database from MySQL to PostgreSQL with pgloader. It covers schema discovery, data type casting, transformations, default values, parallel index building, and limitations involving application queries, triggers, stored procedures, and views.

## Source excerpt

As presented at the PostgreSQL Conference Europe the new version of pgloader is now able to fully migrate a MySQL database, including discovering the schema, casting data types, transforming data and default values. Sakila is the traditional MySQL example database, in this article we're going to fully migrate it over to PostgreSQL.