Converting from other Databases to PostgreSQL

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Updating link - pgdbf is now hosted on Github, removing XBasetoPg as author has replaced it with pgdbf and it is no longer maintained as of 2008)
(Updating links where projects have moved, adding link to SQL::Translator, culling dead links)
Line 2: Line 2:
  
 
* [http://www.easyfrom.net/ 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
 
* [http://www.easyfrom.net/ 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
* [http://troels.arvin.dk/db/rdbms/ Comparison of different SQL implementations] by Troels Arvin
+
* [http://troels.arvin.dk/db/rdbms/ Comparison of different SQL implementations] by Troels Arvin (covers PG 8.4 and MySQL 5.0)
 
* [[Transactional DDL in PostgreSQL: A Competitive Analysis]] by Greg Smith
 
* [[Transactional DDL in PostgreSQL: A Competitive Analysis]] by Greg Smith
 
* [[Migrating from one database to another with Pentaho ETL]] by Nicola Benaglia
 
* [[Migrating from one database to another with Pentaho ETL]] by Nicola Benaglia
Line 9: Line 9:
 
* [http://www.datanamic.com/datadiff-crossdb/ DataDiff CrossDB] is a Windows GUI utility to compare and synchronize/transfer data from PostgreSQL to/from Oracle, MSSQL, MS Access or MySQL databases.
 
* [http://www.datanamic.com/datadiff-crossdb/ DataDiff CrossDB] is a Windows GUI utility to compare and synchronize/transfer data from PostgreSQL to/from Oracle, MSSQL, MS Access or MySQL databases.
 
* [http://www.sqlmaestro.com/products/postgresql/datawizard/ 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.
 
* [http://www.sqlmaestro.com/products/postgresql/datawizard/ 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.
 +
* [https://metacpan.org/module/SQL::Translator SQL::Translator] is a Perl module for translating table definitions between different software.
  
 
== DBase II, III, IV+ ==
 
== DBase II, III, IV+ ==
Line 30: Line 31:
 
== Interbase ==
 
== Interbase ==
  
* [http://honeypot.net/project/dbreplicate DBReplicate - Simplify Interbase->PostgreSQL conversions] by Kirk Strauser
+
* [https://github.com/kstrauser/dbreplicate DBReplicate - Simplify Interbase->PostgreSQL conversions] by Kirk Strauser
  
 
== Microsoft Access ==
 
== Microsoft Access ==
Line 47: Line 48:
 
* [http://www.olschimke.eu/2012/08/07/importing-microsoft-access-mdb-into-postgresql-on-linux-postgres/ Importing Microsoft Access MDB into PostgreSQL on Linux] by Michael Olschimke
 
* [http://www.olschimke.eu/2012/08/07/importing-microsoft-access-mdb-into-postgresql-on-linux-postgres/ Importing Microsoft Access MDB into PostgreSQL on Linux] by Michael Olschimke
 
* [[Microsoft Access to PostgreSQL Conversion]] by Jon Hutchings (2001-07-20)
 
* [[Microsoft Access to PostgreSQL Conversion]] by Jon Hutchings (2001-07-20)
* [http://sevainc.com/Access/ Porting Access97 data to PostgreSQL] at SEVA Software Solutions
 
* [http://www.frankhilliard.com/postgresqlport.cfm Porting ColdFusion from MS Access to PostgreSQL] by Frank Hilliard
 
* [http://www.frankhilliard.com/horrorstory.cfm Porting Horror Story] by Frank Hilliard
 
 
* [http://pgfoundry.org/projects/access2pgsql/ access2pgsql tool] by Mariano Reingart
 
* [http://pgfoundry.org/projects/access2pgsql/ access2pgsql tool] by Mariano Reingart
 
* [http://www.postgresonline.com/journal/archives/24-Using-MS-Access-with-PostgreSQL.html Using MS Access as front end and PostgreSQL as back-end database] by PostgresOnLine Journal - 2008-01-31
 
* [http://www.postgresonline.com/journal/archives/24-Using-MS-Access-with-PostgreSQL.html Using MS Access as front end and PostgreSQL as back-end database] by PostgresOnLine Journal - 2008-01-31

Revision as of 08:32, 19 April 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

Documentation

Scripts, programs

 # 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

Oracle

Progress RDBMS

Converting PostgreSQL Databases to other Databases

Personal tools