Converting from other Databases to PostgreSQL

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Articles and presentations (in reverse chronological order))
(Articles and presentations (in reverse chronological order))
Line 127: Line 127:
 
==== Articles and presentations (in reverse chronological order) ====
 
==== Articles and presentations (in reverse chronological order) ====
  
* [http://tapoueh.org/confs/2013/10/29-pgconfeu-2013 From MySQL to PostgreSQL with pgloader] (English) talk at PostgreSQL Conference Europe, Dimitri Fontaine
+
* [http://tapoueh.org/confs/2013/10/29-pgconfeu-2013 From MySQL to PostgreSQL with pgloader] (English) talk at PostgreSQL Conference Europe, Dimitri Fontaine, 2013-10-29
 
* [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://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://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)

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