Converting from other Databases to PostgreSQL
From PostgreSQL Wiki
Contents |
Non-specific
- Converting data between PostgreSQL and other databases This tool enables you to do data conversion across various databases, supporting PostgreSQL, MySQL, Oracle, SQL Server, 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.
- SSA SQL sniffer SSA SQLsniffer is a proxy that convert Oracle SQL statements sent through the network 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
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
Microsoft SQL Server
- 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)
- Cross Compare of SQL Server, MySQL, and PostgreSQL by Leo Hsu and Regina Obe (2008-05-13)
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
- 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
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
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
