Converting from other Databases to PostgreSQL

From PostgreSQL wiki

(Difference between revisions)
Jump to: navigation, search
(Oracle: add link to orafce; separate utilities and articles into separate sections)
(Microsoft SQL Server: add link to blog series)
Line 53: Line 53:
 
== Microsoft SQL Server ==
 
== Microsoft SQL Server ==
  
 +
* [http://sqlblog.com/blogs/alexander_kuznetsov/archive/tags/PostgreSql/default.aspx Learning PostgreSQL (Alexander Kuznetsov)] - series of blog articles for SQL Server users (2013-10 ~ 2013-11)
 
* [http://www.postgresonline.com/journal/archives/219-SQL-Server-to-PostgreSQL-Converting-table-structure.html Converting SQL Server Table Structure to PostgreSQL] Leo Hsu and Regina Obe (2011-09-03)
 
* [http://www.postgresonline.com/journal/archives/219-SQL-Server-to-PostgreSQL-Converting-table-structure.html Converting SQL Server Table Structure to PostgreSQL] Leo Hsu and Regina Obe (2011-09-03)
 
* [[:Image:5.pdf|Conversion of Microsoft SQL/ASP applications to PostgreSQL]] by Ethan Townsend (2005-06-23)
 
* [[:Image:5.pdf|Conversion of Microsoft SQL/ASP applications to PostgreSQL]] by Ethan Townsend (2005-06-23)

Revision as of 01:33, 10 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