Home > mailing lists

Convert database - Mailing list pgsql-odbc

From	DenBaguse MasRodjie
Subject	Convert database
Date	October 3, 2003 09:29:58
Msg-id	006a01c38991$3aa4d4d0$1500a8c0@deskpro Whole thread Raw
Responses	Re: Convert database (<markw@mohawksoft.com>)
List	pgsql-odbc

How to convert from MySQL to PostgreSQL.

I tried using DBTools, but to slowly. Converting 1 row taken around 0.25 second!!!!

Because i have database over 100MB on MySQL. Maybe over 3 days non-stop to converting.

Is there another way? I'm tried to using my2pg and mysql2pgsql. But error occured.

I want to migrate to PostgreSQL 'cause i have a problem on MySQL.'

MySQL doesn't support sub select on stable version (4.0.14) and too slow sub select query on alpha version (4.1.0).

Is PostgreSQL support that features? How fast it can execute?

Thank's

Roji

From: Hiroshi Inoue
Date: 03 October 2003, 00:25:33
Subject: Re: FUD!! ODBC will not be supported by Microsoft in the future

From: "Dave Page"
Date: 03 October 2003, 09:48:03
Subject: Re: Convert database