Converting from MySQL to PostgreSQL

50 %
50 %
Information about Converting from MySQL to PostgreSQL
Technology

Published on March 12, 2014

Author: akmed13

Source: slideshare.net

Description

How to convert from MySQL to PostgreSQL: discuss history of each, current status, when you might wish to convert, what might motivate you to convert, & how to do so. With references.

PostgreSQL John AshmeadMySQL

MySQL vs PostgreSQL • MySQL covered basics • But a bit flaky in practice, under load • Had looked at PostgreSQL before, but relooked • Others have had similar problems http://tapoueh.org/blog/2013/08/08-MySQL-to-PostgreSQL

• Clay tablets • For taxes (but you knew that) • The map replaces the territory The First Database

Size matters! • Ad hoc tools • SQLite • MySQL • PostgreSQL

Popularity http://db-engines.com/en/ranking

MySQL History • Named after Widenius’s daughter ‘My’! • Version 5.0 with relational integrity, transactions, & stored procedures (i.e. real) in 2005 • Bought by Sun in 2008 • Eaten by Oracle in 2010 • Forks: MariaDB (by Widenius), Drizzle

PostgreSQL • Ingres • Postgres a seQUEL to Ingres • Postgres95 - released on web • Open source version 1996 • Has caught up with MySQL on speed & reliability, still ahead on features • MySQL is open source, PostgreSQL is open project

Decision Points • New Project • Organizational changes • Accumulated stress • Feature lust • Strategic planning

Why • Features: i.e. PostGIS, FDW, Stored procedure languages • Performance • Reliability • Plays nice with others • Others: culture, fear of Larry Ellison, kool-factor, …

MySQL Gotchas • Nulls->default • Case insensitivity • Select 1/0 -> Null • February 31st http://sql-info.de/mysql/gotchas.html

Approachs • hack & go • pivot with frameworks • migration assistants • plan & persevere (step at a time) • halfway houses, i.e. with ODBC

Hack & go • Schema level • Data • Application level • Configuration level • Tools • Documentation • Culture

Pivot with a framework • SQL Alchemy on Python • Ruby on Rails/ ActiveRecord on Ruby • DBI on Perl • Pear DB on PHP

Migration Assistants

Plan & persevere • EnterpriseDB • Internal task force • Culture: desperate late night appeals for help often answered

Summary • PostgreSQL makes sense for new projects • For specific features • As operational core • Should be familiar with alternatives: relational, graph, noSQL, and so on.

Further information • http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL • https://wiki.postgresql.org/wiki/ How_to_make_a_proper_migration_from_MySQL_to _PostgreSQL • http://www.enterprisedb.com/solutions/mysql-vs- postgresql • http://www.slideshare.net/akmed13/converting- from-mysql-to-postgresql

Add a comment

Related presentations

Related pages

Converting from other Databases to ... - PostgreSQL wiki

Converting from other Databases to PostgreSQL. ... Conversion tool for migrating from MySQL to PostgreSQL by PostgreSQL Inc. Converting MySQL to ...
Read more

Convert / Sync from MySQL to PostgreSQL

MySQL to PostgreSQL database ... DBConvert and DBSync for MySQL and PostgreSQL are reliable database ... Improved engine allows converting large ...
Read more

PostgreSQL to MySQL - Intelligent Converters

PostgreSQL to MySQL; PostgreSQL to Oracle; ... PostgreSQL-to-MySQL is a program to migrate PostgreSQL databases to MySQL, MariaDB or Percona server.
Read more

MySQL to PostgreSQL - convert-in.com

PostgreSQL script file. MySQL to PostgreSQL converter allows users to migrate MySQL database into PostgreSQL format even when there is no connection to ...
Read more

PostgreSQL to MySQL Migration and Sync - convertdb.com

PostgreSQL to MySQL conversion and ... from MySQL to PostgreSQL, from MySQL to MySQL and from ... Improved engine allows converting large databases in ...
Read more

Re: Converting MySQL tinyint to PostgreSQL

... Converting MySQL tinyint to PostgreSQL. From: Martijn van Oosterhout To: Dawid Kuroczko Cc:
Read more

PostgreSQL: The world's most advanced open source database

The official site for PostgreSQL, the world's most advanced open source database. Skip site navigation (1) Skip section navigation (2) Search. Peripheral ...
Read more

Lightbox Technologies Inc - pg2mysql

Lightbox Technologies Inc. specializes in custom application development, web applications, web hosting, ... (PostgreSQL to MySQL Converter)
Read more

Converting MySQL Databases (MySQLToSQL)

Converting MySQL Databases (MySQLToSQL) ... Before converting objects, review the project conversion options in the Project Settings dialog box.
Read more