PostgreSQL Conversion Documentation

Converting to PostgreSQL from other Databases

Non-specific

• Comparison of different SQL implementations by Troels Arvin

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
• Notes by Vijay Deval on Porting data from dBASE IV to PostgreSQL (2002-09-07)
• Pg2xbase (DBF format) Conversion Utility by Piotr Klaban

FileMaker Pro

• FileMaker to PostgreSQL Migration with FmPro Migrator on Windows by David Simpson (2004-04-27)
• Porting from FileMaker Pro to PostgreSQL by Michelle Murrain (24th August 2001)

IBM DB2

• Migrating from DB2 to PostgreSQL ( PDF | DOC | ZIP )

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
• 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
• PostgreSQL and Microsoft Access by Joel Burton

Microsoft SQL Server

• Conversion of Microsoft SQL/ASP applications to PostgreSQL (PDF) 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)
• HOWTO : Microsoft SQL Server to PostgreSQL Migration by Ian Harding (2001-09-17)

MySQL

• Backend Database Switcheroo Howto Part I by Nathan Matias
• Backend Database Switcheroo Howto Part II by Nathan Matias
• Conversion tool for migrating from MySQL to PostgreSQL by PostgreSQL Inc.
• How-To: Migrating from MySQL to PostgreSQL by Zach Beane
• 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
• Things to find out about when moving from MySQL to PostgreSQL by Joel Burton (8th April 2001)
• Converting MySQL to PostgreSQL - from en.wikibooks.org

Oracle

• Porting JDBC applications from Oracle to PostgreSQL (pdf) by Chris Drawater (2006-03-24)
  
  
• Installing PostgreSQL on Solaris 10 with JDBC + Oracle conversion notes (pdf) by Chris Drawater
• 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
• Oracle Style Data Dictionary views for PostgreSQL by Chris Brown

Converting PostgreSQL Databases to other Databases

• PostgreSQL to InterBase dump file converter by Dobrica Pavlinusic