Getting Mysql data into Postgres: least painful methods?

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: ktanzer(at)desc(dot)org
Subject: Getting Mysql data into Postgres: least painful methods?
Date: 2013-01-11 23:54:44
Message-ID: CAD3a31U0he2y491VVP-y=oUbnGa55EFMSS34xQJjvsWmVicp_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm wondering if anyone can point me towards a good method for moving mysql
data into Postgres? I've done some web searching, and found documentation
from various years, but it's not clear what's current and what works best.
Much of what I found seems to be flame war material (why Postgres is
better), or is both old and seemingly involved and complex.

Here's the fuller description of what I'm trying to do. I've got a dataset
(a UMLS* *Metathesaurus subset) that I need to get into a Postgres
database. It's all reference data, and so will be read-only. There's no
functions or logic involved. I anticipate having to update it at least
quarterly, so I'd like to get to a well-grooved import process.

The data as distributed can be had in Oracle or Mysql formats. (I already
gave them my two cents to include Postgres.) I did see some information
about modifying the Mysql distribution files to make them
Postgres-compatible, but I thought (perhaps foolishly) it would be easier
to bring them into Mysql, and from there export them to Postgres.

A recurring idea seemed to be to use:

mysqldump -v --compatible=postgresql umls_test > dumpfile.sql

followed by

sed -i "s/\\\'/\'\'/g" dumpfile.sql

but that didn't bring me much success. I figure this has to be a fairly
common need, and hopefully by 2013 there's an easy solution. Thanks in
advance!

Ken

--
AGENCY Software
A data system that puts you in control
*http://agency-software.org/*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-01-12 00:12:29 Re: Getting Mysql data into Postgres: least painful methods?
Previous Message Gavin Flower 2013-01-11 22:22:06 Re: >