Converting from other Databases to PostgreSQL

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Microsoft SQL Server: add link to blog series)
(pgloader)
Line 1: Line 1:
 
== Non-specific ==
 
== Non-specific ==
  
 +
* [https://github.com/dimitri/pgloader pgloader] knows how to load data from MySQL, SQLite, dBase files, CSV files and fixed-width data files, and more. Released under The PostgreSQL Licence.
 
* [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 (covers PG 8.4 and MySQL 5.0)
 
* [http://troels.arvin.dk/db/rdbms/ Comparison of different SQL implementations] by Troels Arvin (covers PG 8.4 and MySQL 5.0)

Revision as of 08:23, 22 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