Converting from other Databases to PostgreSQL

From PostgreSQL wiki

Contents 1 Non-specific 2 DBase II, III, IV+ 3 DBF Format 4 FileMaker Pro 5 IBM DB2 6 Interbase 7 Microsoft Access 8 Microsoft SQL Server 9 MySQL 9.1 Documentation 9.2 Scripts, programs 10 Oracle 11 Progress RDBMS 12 Converting PostgreSQL Databases to other Databases

Non-specific

• Converting data between PostgreSQL and others database formats ESF Database Migration Toolkit enables you to transfer data across various databases, supporting PostgreSQL, MySQL, Oracle, SQL Server, IBM DB2, Informix, Microsoft Access, Microsoft Excel, dBase, Foxpro, Firbird, SQLite etc. - by Martin Williams
• Comparison of different SQL implementations by Troels Arvin
• Transactional DDL in PostgreSQL: A Competitive Analysis by Greg Smith
• Migrating from one database to another with Pentaho ETL by Nicola Benaglia
• PostgreSQL database conversion software Bi-directional database migration and synchronization between PostgreSQL, MySQL, MS SQL, MS Access, MS FoxPro and MS Excel. - by Nataly Peterson
• dataPro Conversion tool for PostgreSQL, SQLite, MySQL, Oracle, SQL Server and Microsoft Access. Transfer database objects between different databases and servers, convert tables schema and migrate data from one database type to another.
• DataDiff CrossDB is a Windows GUI utility to compare and synchronize/transfer data from PostgreSQL to/from Oracle, MSSQL, MS Access or MySQL databases.
• PostgreSQL Data Wizard is a Windows GUI utility to transfer both schema and data from any ADO-compatible source (like MS Access, MySQL, SQL Server, Oracle, etc) to PostgreSQL.

DBase II, III, IV+

• Convert .dbf files into PostgreSQL by Tomasz Judycki

DBF Format

• A Visual Basic utility to convert Dbase III, IV, and V by Dennis Bazan
• DBF to PostgreSQL tool by Stephan Richter
• Porting data from dBASE IV to PostgreSQL by Vijay Deval (2002-09-07)
• Pg2xbase (DBF format) Conversion Utility by Piotr Klaban
• PgDBF : Simplified and optimized replacement for XBaseToPg by Kirk Strauser
• XBaseToPg : Current, maintained branch of the Xbase project by Kirk Strauser

FileMaker Pro

• Porting from FileMaker Pro to PostgreSQL by Michelle Murrain (24th August 2001)

IBM DB2

• Migrating from DB2 to PostgreSQL

Interbase

• DBReplicate - Simplify Interbase->PostgreSQL conversions by Kirk Strauser

Microsoft Access

• exportSQL - a Microsoft Access module which exports Access Database into MySQL, mSQL and PostgreSQL by Dobrica Pavlinusic. Based on the work of Pedro Freire
• MDB Tools by Brian Bruns
  • A quick way to dump all tables as tsv or csv files

for TT in $(mdb-tables file.mdb); do
     mdb-export -Q -d $'\t' -D '%%Y-%%m-%%d %%H:%%M:%%S' file.mdb "$TT" > "${TT}.tsv"
done

for TT in $(mdb-tables file.mdb); do
     mdb-export -D '%%Y-%%m-%%d %%H:%%M:%%S' file.mdb "$TT" > "${TT}.csv"
done

• Microsoft Access to PostgreSQL Conversion by Jon Hutchings (2001-07-20)
• Porting Access97 data to PostgreSQL at SEVA Software Solutions
• Porting ColdFusion from MS Access to PostgreSQL by Frank Hilliard
• Porting Horror Story by Frank Hilliard
• access2pgsql tool by Mariano Reingart
• Using MS Access as front end and PostgreSQL as back-end database by PostgresOnLine Journal - 2008-01-31

Microsoft SQL Server

• Converting SQL Server Table Structure to PostgreSQL Leo Hsu and Regina Obe (2011-09-03)
• Conversion of Microsoft SQL/ASP applications to PostgreSQL by Ethan Townsend (2005-06-23)
• Converting your data from MS SQL Server 7 to PostgreSQL 7.1.x by Ryan C. Bonham (2002-01-05)
• Microsoft SQL Server to PostgreSQL Migration by Ian Harding (2001-09-17)
• Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features BostonGIS (2010-06-01)
• Cross Compare of SQL Server 2005, MySQL 5, and PostgreSQL 8.3 by Leo Hsu and Regina Obe (2008-05-13)
• Cross Compare of SQL Server 2008, MySQL 5.1, and PostgreSQL 8.4 by Leo Hsu and Regina Obe (2009-08-15)
• Universal Unique Identifiers PostgreSQL SQL Server Compare Demonstrates how to implement SQL Server NEWID() GUID uniqueidentifier type in PostgreSQL by Leo Hsu and Regina Obe (2010-10-07)

MySQL

Documentation

• Backend Database Switcheroo Howto Part I by Nathan Matias
• Backend Database Switcheroo Howto Part II by Nathan Matias
• How-To: Migrating from MySQL to PostgreSQL by Zach Beane
• Things to find out about when moving from MySQL to PostgreSQL by Joel Burton (8th April 2001)
• Why PostgreSQL Instead of MySQL: Comparing Reliability and Speed in 2007 by Greg Smith
• Cross Compare of SQL Server, MySQL, and PostgreSQL by Leo Hsu and Regina Obe (2008-05-13)
• How to make a proper migration from MySQL to PostgreSQL
• Migrating a community platform from Mysql to PostgreSQL by Andreas Scherbaum (Prato, 2007)
• MySQL functions for PostgreSQL by Pavel Stěhule

Scripts, programs

• Free MySQL to Postgres Migration Wizard by EnterpriseDB v1.1 by EnterpriseDB Corporation. Available without registration via PostgreSQL installer wizard.
• Conversion tool for migrating from MySQL to PostgreSQL by PostgreSQL Inc.
• my2pg.py Simple python script designed to load wikipedia MySQL dumps to PostgreSQL -- site currently (2011-09-23) returns error 503
• Converting MySQL to PostgreSQL - from en.wikibooks.org
• my2pg.pl - A Perl script used to convert a MySQL database dump to PostgreSQL-compatible format, by Maxim Rudensky and Valentine Danilchuk
• mysql2pgsql - A Perl script used to convert MySQL databases dump to a PostgreSQL-compatible format
• MySQL PHP to PostgreSQL by Michael Kohn
• Migrates MySQL to PostgreSQL Ruby script by Max Lapshin
• py-mysql2pgsql Python script to convert MySQL database to PostgreSQL compatible file or export directly to a PostgreSQL server
• my2pg.py MySQL to PostgreSQL database conversion (not the same as above)

Oracle

• PostgreSQL for Oracle DBAs by Richard Stephan (2007-06-01)
• Porting JDBC applications from Oracle to PostgreSQL by Chris Drawater (2006-03-24)
• Related documents for J2EE, Tomcat, and Oracle migrations by Chris Drawater (2007-01-15)
• Interview with Mark Stosberg (From Oracle/tcl to PostgreSQL/Perl) by Robert Treat (2004-10-24)
• Porting from Oracle PL/SQL
• Ora2Pg - Oracle to PostgreSQL database schema converter by Gilles Darold
• Oracle to Postgres Conversion by James Shannon, Ben Adida, and Don Baccus
• Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features BostonGIS (2010-06-01)
• Porting Oracle Applications to PostgreSQL by Peter Eisentraut (PGCon 2008)

Progress RDBMS

• Convert Progress RDBMS to PostgreSQL by Tomasz Judycki

Converting PostgreSQL Databases to other Databases

• PostgreSQL to InterBase dump file converter by Dobrica Pavlinusic