From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: Re: Database Conversion
Date: Thu, 4 Sep 2008 16:38:03 +0300
User-Agent: KMail/1.9.7
Cc: Carol Walter <walterc@indiana.edu>
References: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
In-Reply-To: <9B852776-95B1-41E2-B6A8-DFA92F7C410F@indiana.edu>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200809041638.04145.achill@matrix.gatewaynet.com>

=CE=A3=CF=84=CE=B9=CF=82 Thursday 04 September 2008 16:24:34 =CE=BF/=CE=B7 =
Carol Walter =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> Hello, All,
>=20
> I have a new faculty member who has a large database that is in =20
> MySQL.  We don't support MySQL so the database needs to be ported to =20
> PostgreSQL.  Her GA, who know MySQL, says that he has a query that he =20
> will run that will put the data into postgres.  I thought that the =20
> data would have to be output to a text file and then copied into =20
> postgres.  I don't know MySQL.  I've done a conversion from Oracle =20
> and this is how I did it.  Is he correct that he can put the data =20
> into a postgres database by running a MySQL query?  It doesn't sound =20
> possible to me.
>=20

We recently did a conversion from MS Access (i dont know details) to pgsql =
8.3.3.
The MS Access-aware guy just declared the correct postgresql ODBC settings,
i adjusted the pgsql backend to accept connections from the MS workstation,
then performed an EXPORT from MS Access to the pgsql datasource
and thats all.
Of course all i got was the exact MS Access tables, which then were useful
to populate my new designed pgsql tables.

One caveat here, most commonly, is the design of the DB.
The lower end you get mysql->sql server->access->COBOL, etc...
the greater chance you need a re-engineering of the schema.

> Carol
>=20


=2D-=20
Achilleas Mantzios