Converting from other Databases to PostgreSQL

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Culling dead links)
(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)
Line 18: Line 18:
 
* [[:Image:26.zip|A Visual Basic utility to convert Dbase III, IV, and V]] by Dennis Bazan
 
* [[:Image:26.zip|A Visual Basic utility to convert Dbase III, IV, and V]] by Dennis Bazan
 
* [[Porting data from dBASE IV to PostgreSQL]] by Vijay Deval (2002-09-07)
 
* [[Porting data from dBASE IV to PostgreSQL]] by Vijay Deval (2002-09-07)
* [http://pgdbf.sourceforge.net/ PgDBF : Simplified and optimized replacement for XBaseToPg] by Kirk Strauser
+
* [https://github.com/kstrauser/pgdbf PgDBF : Simplified and optimized replacement for XBaseToPg] by Kirk Strauser
* [http://honeypot.net/project/xbasetopg XBaseToPg : Current, maintained branch of the Xbase project] by Kirk Strauser
+
  
 
== FileMaker Pro ==
 
== FileMaker Pro ==

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