Re: Migrating MySQL data to PostgreSQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Orr, Steve" <sorr(at)rightnow(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Migrating MySQL data to PostgreSQL
Date: 2002-08-15 08:48:56
Message-ID: 200208150948.56717.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 14 Aug 2002 11:33 pm, Orr, Steve wrote:
> pgsql Newbie here...
>
> I need to migrate TONS of data out of MySQL and into PostgreSQL 7.2.1.
> There are BLOBs and text fields with embedded commas in the MySQL source
> data. What's the best way to do this? mysqldump? Other tools?

Look to the postgresql.org website. I think in techdocs.postgresql.org there
are some articles on porting different databases to/from PostgreSQL. I'd
suspect the blob's are going to give you the most trouble.

- Richard Huxton

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Preben Holm 2002-08-15 09:33:57 Why choose PostreSQL and not MySQL or Oracle!!
Previous Message Hans Meyer 2002-08-15 08:46:17 DB2->PostgreSQL question on user permissions and views