Converting from other Databases to PostgreSQL

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Oracle: add link to oracle_fdw, which could be useful for some kinds of migration)
(Oracle: add link to orafce; separate utilities and articles into separate sections)
Line 111: Line 111:
 
== Oracle ==
 
== Oracle ==
  
 +
=== Utilities, tools, scripts etc. ===
 +
 +
* [http://ora2pg.darold.net/ Ora2Pg - Oracle to PostgreSQL database schema converter] by Gilles Darold
 +
* [http://oracle-fdw.projects.pgfoundry.org/ PostgreSQL Foreign Data Wrapper for Oracle (oracle_fdw)] - an [[Fdw|FDW]] providing support to access Oracle databases from within PostgreSQL
 +
* [http://orafce.projects.pgfoundry.org/ Orafce] - implements common Oracle functions in PostgreSQL for compatibility
 +
 +
=== Documentation, articles, presentations etc. ===
 +
 +
==== PostgreSQL documentation ====
 +
* [http://www.postgresql.org/docs/current/interactive/plpgsql-porting.html Porting from Oracle PL/SQL]
 +
 +
==== Articles and presentations (in reverse chronological order) ====
 +
 +
* [http://wiki.cenatic.es/wikiesp/index.php/Procedimiento_de_An%C3%A1lisis_y_Planificaci%C3%B3n_de_Migraci%C3%B3n_de_Oracle_10g_R2_a_PostgreSQL_9.1.3 Analysis and Planning Process for Migration from Oracle 10g R2 to PostgreSQL 9.1.3] (Spanish) by the Spanish National Competence Center for the Application of Opensource Technologies [http://www.cenatic.es (CENATIC)] (2012-06)
 +
* [http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features] BostonGIS (2010-06-01)
 +
* [http://wiki.kandalaya.org/cgi-bin/twiki/view/Main/MigratingOracleToPostgreSQL Migrating Oracle Databases to PostgreSQL using Xen on Debian GNU/Linux] by Raj Mathur (Kandalaya) (2008-12-26)
 +
* [http://www.pgcon.org/2008/schedule/track/Tutorial/62.en.html Porting Oracle Applications to PostgreSQL] by Peter Eisentraut (PGCon 2008)
 
* [[PostgreSQL for Oracle DBAs]] by Richard Stephan (2007-06-01)
 
* [[PostgreSQL for Oracle DBAs]] by Richard Stephan (2007-06-01)
 
* [[:Image:Pg 8.1 J2EE v1.0.pdf|Porting JDBC applications from Oracle to PostgreSQL]] by Chris Drawater (2006-03-24)
 
* [[:Image:Pg 8.1 J2EE v1.0.pdf|Porting JDBC applications from Oracle to PostgreSQL]] by Chris Drawater (2006-03-24)
* [http://www.holindis.co.uk/ Related documents for J2EE, Tomcat, and Oracle migrations] by Chris Drawater (2007-01-15)
+
** [http://www.holindis.co.uk/ 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)
 
* [[Interview with Mark Stosberg (From Oracle/tcl to PostgreSQL/Perl)]] by Robert Treat (2004-10-24)
* [http://www.postgresql.org/docs/current/interactive/plpgsql-porting.html Porting from Oracle PL/SQL]
 
* [http://ora2pg.darold.net/ Ora2Pg - Oracle to PostgreSQL database schema converter] by Gilles Darold
 
 
* [[Oracle to Postgres Conversion]] by James Shannon, Ben Adida, and Don Baccus
 
* [[Oracle to Postgres Conversion]] by James Shannon, Ben Adida, and Don Baccus
* [http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features] BostonGIS (2010-06-01)
 
* [http://www.pgcon.org/2008/schedule/track/Tutorial/62.en.html Porting Oracle Applications to PostgreSQL] by Peter Eisentraut (PGCon 2008)
 
* [http://wiki.kandalaya.org/cgi-bin/twiki/view/Main/MigratingOracleToPostgreSQL Migrating Oracle Databases to PostgreSQL using Xen on Debian GNU/Linux] by Raj Mathur (Kandalaya)
 
* [http://wiki.cenatic.es/wikiesp/index.php/Procedimiento_de_An%C3%A1lisis_y_Planificaci%C3%B3n_de_Migraci%C3%B3n_de_Oracle_10g_R2_a_PostgreSQL_9.1.3 Analysis and Planning Process for Migration from Oracle 10g R2 to PostgreSQL 9.1.3] (Spanish) by the Spanish National Competence Center for the Application of Opensource Technologies [http://www.cenatic.es (CENATIC)]
 
* [http://oracle-fdw.projects.pgfoundry.org/ PostgreSQL Foreign Data Wrapper for Oracle (oracle_fdw)] - an [[Fdw|FDW]] providing support to access Oracle databases from within PostgreSQL
 
  
 
== Progress RDBMS ==
 
== Progress RDBMS ==

Revision as of 05:59, 3 November 2013

Contents

Non-specific

DBase II, III, IV+

DBF Format

FileMaker Pro

IBM DB2

Interbase

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 SQL Server

MySQL

Scripts, programs

2013

Previously

 # To install mysql2psql (under ubuntu 11.10): No need to get from github, just:
 sudo apt-get install ruby gems libmysqlclient-dev libpq-dev
 gem install mysql pg mysql2psql
 # To get info about the mysql socket:
 netstat -l | grep mysql
 mysql2psql # creates a .yml templae
 vi mysql2psql.yml # edit the template
 mysql2psql # connects to mysql database and write into postgres database

Documentation

Oracle

Utilities, tools, scripts etc.

Documentation, articles, presentations etc.

PostgreSQL documentation

Articles and presentations (in reverse chronological order)

Progress RDBMS

Converting PostgreSQL Databases to other Databases

Personal tools